New column depending on the row condition

Hello Experts,

I have a requirement in which I have a category and sub category for which I want to create Other Column depending on the Values, i.e if Values are equal and opposite for same Category what ever may be the sub category the Other will have Value else 0 or blank. PFA with the input data sample and the desired output.

Thanks in advance

Sample-Alteryx.xlsx

Preparation

Accepted answers

Hi @ferha_jafri

Here is how you can do it.

Workflow:

1. Using record id to set as unique id.

2. Using formula tool to get opposite value.

3. Using join tool to join on category, actual value and opposite value numbers.

4. Using find and replace tool to do vlookup using recordid to add other column.

Hope this helps : )

Other column.yxmd

All comments

Hi @ferha_jafri ,

Could you provide the output you need for your sample ? I'm not sure to get the logic here.

Hi @ferha_jafri

Here is how you can do it.

Workflow:

1. Using record id to set as unique id.

2. Using formula tool to get opposite value.

3. Using join tool to join on category, actual value and opposite value numbers.

4. Using find and replace tool to do vlookup using recordid to add other column.

Hope this helps : )

Other column.yxmd

Thanks it worked.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15865

MarqueeCrew 13708

apathetichell 13703