Add a column by concatenating values in the result

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

Other column.yxmd

Sample-Alteryx.xlsx

Preparation

Accepted answers

atcodedog05

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 : )

Other column (1).yxmd

All comments

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.

Other column.yxmd

atcodedog05

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 : )

Other column (1).yxmd

ferha_jafri

Thanks Again 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703