How to store null value or empty value in numeric field of infotable

[AP_10343008]

How to store null value or empty value in numeric field of infotable

[Velkumar]

Hi @AP_10343008 

You can assign a null value to your field and add a row to infotable

/VR

[AP_10343008]

Thanks. In the scenario iam using two columns together as primary key. One column is string datatype and another column is  number datatype together considering as unique row. In Some combination i want to leave number column empty. As number column is primary key, it should not be empty. So how to pass null value to number column even if it is primary key. 

[Velkumar]

Hi @AP_10343008 

Please refer to this article - Article - CS352005 - Getting Key field [xxx] had no value exception when adding data table entry without primary key value in ThingWorx Platform (ptc.com)

Based on this, if you are storing data in DataTable it is not possible to have null primary key value

/VR

[AP_10343008]

Ok Thanks. Then Ill Add any dummy data.
Is it possible to show the unique id column in grid, at the same time the particular value "part" in the column need to be invisible as it is supposed to be blank.

[Velkumar]

Hi @AP_10343008 

Could you please post some screenshots to understand better

/VR