Null value is ignored in concatenated string

Question

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 1Column2Column 3ab cdefgh

Currently I am getting output as below

Concatenated Stingab|cdef|gh

Expected Output

ab|null|cd

ef|gh|null

RobertOdera · Answer

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!

ForRohan2020.yxmd

Qiu · Answer

@Rohan2020

A bit different approach.

1225-Rohan2020.yxmd

pedrodrfaria · Answer

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.

New Workflow10.yxmd