Below is my payload.
Id, Name, Country, L4_Name, L5_Name, Region
1, ABC, ARE, L4_RH, L5_YN, US
2, PQR, ITI, L4_AB, L5_JW, CAN
3, XYZ, GPB, L4_PQ, L5_JW, EUR
4, MNE, ARE, L4_BN, L5_JW, KEN
If Country = ‘ARE’ and “L4_Name” = “L4_RH” then update Region as “EMEA”; But if “L4_Name” = “L4_BN” and “L5_Name” =”L5_JW’ and country is “ARE” then update “Region” to “APAC”
NA. Unable to achieve this yet.
New contributor
Santosh Gore is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.