Concat Problem

[Gamaliel]

Hello Experts,

I am having a trouble with concatenation between multiple columns with account names. What I have in input are accounts from multiple columns and I want to concatenate all of them just like in the picture below. The first part in the workflow is to determine which columns have "total" because this is an identifier of columns having account names.

E.g. I want to concatenate 1000 Checking account (main) and 1001 Comerica Checking (sub account). However I want to retain only 1001 as the account code not the 1000.

For 1201 Notes Receivable -ST, no need to concatenate because it has no sub account following it. 

Input:

Desired Output:

Thanks for your help. Please see attached workflow.

[atcodedog05]

Hi @Gamaliel 

Check and let me know does this work for your usecase.

Workflow:

Hope this helps : )