Conditional mapping

[APMS]

Hello,

I need to implement following mapping logic. Please suggest if I should use applymap in scripting or if..else condition in front end. Thanks.

Condition 1	Condition 2	Condition 3	Final Value
100	101	All values	Category 3
100	102	All values	Category 1
100	All other	All values	Category 2
200	All values	201	Category 1
200	All values	202	Category 3
200	All values	All Other	Category 2

[Chanty4u]

Try this

if(Condition1 = 100 and Condition2 = 101 and Condition3 = 'All values', 'Category 3',

   if(Condition1 = 100 and Condition2 = 102 and Condition3 = 'All values', 'Category 1',

      if(Condition1 = 100 and Condition3 = 'All values', 'Category 2',

         if(Condition1 = 200 and Condition3 = 201, 'Category 1',

            if(Condition1 = 200 and Condition3 = 202, 'Category 3',

               if(Condition1 = 200 and Condition3 = 'All Other', 'Category 2', null))))))

Check the braces and fieldnames

[APMS]

Hello,

Thank you for you response. The  'All values' mapping needs to be applied to multiple numeric values from the source table that cannot be added to mapping . Additionally there are other mapping that does not have condition2 or 3. If I use applyMap in scripting, will the if else conditions in sheets override the final value only for exceptions?

Please see attached file.