How to make certain double variable column values as NULL while using add data row activity

Build
#1

I have a data table DT. I have 5 columns with column datatype as double. some columns will not have any value( i.e it should be blank) while using Add Data Row activity. How to make it null inside Add Data Row activity.

Can anyone please help me…

#2

Hi @rifnanahas

Use add data row and in array row you can give it as String.IsNullor empty

Thanks
Ashwin.S

#3

This is not working because when I build datatable DT, I made the column name types as int and double…
So its showing error like : Add Data Row: Input string was not in a correct format.Couldn’t store < > in SL NO Column. Expected type is Int32.

#4

Hi @rifnanahas

Based on assign activity give it as null

Thanks
Ashwin.S

#5

Is there any way to calculate each column value and make these total as next row

#6

Hi @rifnanahas,
You can use for each row and inside the loop use assign to enter value in the column which is required.Give the row index in assign value to enter value in particular column.