Remove empty columns and concatenate

Hi all,

I have an input file that has a primary unique column ID and name columns (1 to n). Some of it might be empty (null). I need to concatenate the name fields for those that doesn't have empty cells by adding a delimiter " & ". I was trying to do using summarize tools (group by ID) and then concatenate. But I am not able to solve it. Really appreciate looking into this issue. Please see the attached sample Input and Required Sample Output.

Sample Input.PNG

Sample Output.PNG

Workflow

Accepted answers

griffinwelsh

This is a dynamic solution that should work for you.

Concat columns.yxmd

All comments

griffinwelsh

This is a dynamic solution that should work for you.

Concat columns.yxmd

Saratnarendran

Thanks a lot @griffinwelsh . It worked.

Just a quick question out of curiosity, what change should I make on the above workflow so that I can have the combined columns without losing old columns. See below output format I am referring to and kindly let me know if you have questions.

Modified Output format.PNG

griffinwelsh

@Saratnarendran you can just join on based on record id the output from the recordid tool and the final output of the sample I attached

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335