Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Null value is ignored in concatenated string

Rohan2020
7 - Meteor

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 3
ab cd
efgh 

 

Currently I am getting output as below 

Concatenated Sting
ab|cd
ef|gh

 

Expected Output

ab|null|cd

ef|gh|null
4 REPLIES 4
messi007
15 - Aurora
15 - Aurora

@Rohan2020,

 

Please see below:

 

messi007_0-1608826241049.png

Hope that helps,

 

Regards,

pedrodrfaria
13 - Pulsar

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.

pedrodrfaria_0-1608827461933.png

 

 

Pedro.

Qiu
20 - Arcturus
20 - Arcturus

@Rohan2020 

A bit different approach.

1225-Rohan2020.PNG

RobertOdera
13 - Pulsar

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.

 

RobertOdera_0-1608922401034.png

 

Please see the attachment. Cheers!

Labels