New column depending on the row condition

[ferha_jafri]

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

[Jean-Balteryx]

Hi @ferha_jafri ,

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

[atcodedog05 · Accepted solution]

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

[ferha_jafri]

Thanks it worked.