Add a column by concatenating values in the result

[ferha_jafri]

Hello Experts,

I have a requirement in which I want a Concat column  by concatenating the Sub categories for equal and opposite present in Other. I am attaching the workflow and the excel with the desired output present in the Output sheet.

Thanks in advance

[Jean-Balteryx]

Hi @ferha_jafri ,

Here is your workflow modified to include concatenation of sub-categories !

It adds the second sub-category in the Join then concatenates both in the Formula tool then adds it in the Find and Replace tool.

[atcodedog05 · Accepted solution]

Hi @ferha_jafri 

I have updated the workflow to meet the requirement.

Workflow:

Adding a block.

1. Using formula tool to get abs value of others which had joined.

2. Using summarize tool to groupby on category and abs to generate conacat text and get first row id of this combination.

3. Adding this back to the data.

Hope this helps : )

[ferha_jafri]

Thanks Again 🙂