Adding Null values in Generate Data table Activity

[rmathur-consultant]

Hello I a having one issue whuile using Generate Data table:

My text data is :
“Data1,Number1,Number2,Data2”

I want to convert this into a datatable so I used generate Data Table and use comma as comma separate value.
the expected output is :

but the activity skipping the null value and generating :
Column 1 | Column 2 | Column 3 | Column 4
Data1 | Number 1 | Number 2 | Data 2

Can anyone assist me on this?

Thanks,
Rishabh Mathur

[Anil_G]

@rmathur-consultant

“Data1,Number1,Number2,Data2”

@rmathur-consultant

If you want a blank value then your text should be like this

“Data1,Number1, ,Number2,Data2”

Add a space

cheers

[Yoichi]

Hi,

@rmathur-consultant

Data1,Number1,Number2,Data2

It should be as the following.

"Data1,Number1,,Number2,Data2"

Regards,