topic Re: Conditional mapping in App Development

Conditional mapping

APMS — Tue, 13 Jun 2023 17:45:40 GMT

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

Re: Conditional mapping

Chanty4u — Tue, 13 Jun 2023 18:14:11 GMT

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

Re: Conditional mapping

APMS — Tue, 13 Jun 2023 18:27:46 GMT

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.