Adding Null values in Generate Data table Activity

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

My text data is :

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?

Rishabh Mathur


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

“Data1,Number1, ,Number2,Data2”

Add a space



It should be as the following.