Null value is ignored in concatenated string

[Rohan2020]

I am reading data from excel file and creating the | separated string one value for all the columns. But if any of the column is blank or null it is not showing in the string value but  getting ignored. Also the string length is dynamic.

eg. 

Excel file Input

Column 1	Column2	Column 3
ab		cd
ef	gh

Currently I am getting output as below 

Concatenated Sting

ab|cd

ef|gh

Expected Output

ab|null|cd

ef|gh|null

[messi007]

@Rohan2020,

Please see below:

Hope that helps,

Regards,

[pedrodrfaria]

Hi @Rohan2020 

I have attached a workflow that will accomplish this for you and it is not limited to the amount of columns, so if you were trying to concatenate more than 3 columns for example, you would be able to do this automatically instead of manually adding the additional column in the concatenation.

Pedro.

[Qiu]

@Rohan2020 

A bit different approach.

[RobertOdera]

Hi, @Rohan2020 

Please try the below and Like + mark as an acceptable solution if it works for you.

Please explore the multi-field tool as it might more 'robust' if your use-case needs to treat a variable number of columns input.

Please see the attachment. Cheers!