Create a new field based in multiple conditions

[Sifiso]

Hi all

I want to create a new column, some values in this new column should only depend on the product type (only one condition) and other values should depend on product type and location (two conditions)

[JarekSkudrzyk · Accepted solution]

@Sifiso 

hi, you can use formula tool or a mapping file and join tool. I recommend the latter as it is easier to maintain.
You can also use a combination of both - please find example solution.

[Sifiso]

Thank you Jarek

[JarekSkudrzyk]

@Sifiso you are welcome, glad I could help.