How to write null values to the "Add Data Row"

Help Studio
, ,
1

How to write null values to the “Add Data Row”

I have some null values in the queue, like “Email”, “Phone #” etc. How can I write the same null values to the “Add Data Row”? I am currently getting “Object reference is not found error” where there is no value for any of the fields

2

Hi,

How about using Nothing as the following if the column can accept null?

image

Regards,

3

{“A”,“”,“C”,“”}

4

Sorry, I didn’t understand that. Right now I am pulling it from the queue like this "in_TransactionItem.SpecificContent(“Email_Id”).ToString which is throwing me “Object reference not set to an instance of an object”. I have a bunch of columns like “Name”, “Email_Id”, “Phone Num”, “Address” etc, in which “Email_Id” and “Phone Num” are optional and thus it could be uploaded as null into the Queues.

5

Hi,

Can you try as the following?

strEmailID = if(in_TransactionItem.SpecificContent("Email_Id") is Nothing, "",in_TransactionItem.SpecificContent("Email_Id").ToString)

image

Regards,