Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

how can I merge serval fields by some signal ,and skip the empty fields.

WuCong
8 - Asteroid

such as Fields 1 -10.

when 2 is empty ,will only merge 1,3-10. 1;3;4;5;6;7;8;9;10

 

how can I get the result?

1 REPLY 1
APrasad_Tri
Alteryx Alumni (Retired)

Hi @wu cong? , thank you for reaching out.

 

After applying merge on all the columns, you can replace ';;' with a single ';'Another method is Unpivot the table to set column names as rows.

 

delete the missing values

Pivot the table back to its original form. Please note you need row number/source row number / unique primary key to bring all the values in the same order.

 

 

Use the Merge transform to concatenate the row values with ;

 

I hope this helps. Please let us know if you have any additional issues.

 

Best,

Apeksha Prasad