Create a new field based in multiple conditions

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)

Preparation

Accepted answers

JarekSkudrzyk

@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.

New Workflow5.yxmd

All comments

JarekSkudrzyk

@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.

New Workflow5.yxmd

Sifiso

Thank you Jarek

JarekSkudrzyk

@Sifiso you are welcome, glad I could help.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335