IF Condition

[#1]

Hello Experts,

Need your help on applying IF condition.

We have 5 groups related to Master Data and out of 5, 3 are related to Customer Master

EDM.EMEACust

EDM.CUSTOMER

EDM.LACust

EDM.MTB

EDM.PTP

First 3 groups are realted to Customer master... 4 is for Vendor and 5 is for Finance..

My result should in this model.

Customer Master

Vendor Master

Finance Master

[robert_mika]

Try:

=if(match([Master Data],'EDM.EMEACust','EDM.CUSTOMER','EDM.LACust'),'Custome Master',IF([Master Data]='EDM.MTB','Vendor Master',IF([Master Data]='EDM.PTP','Finance Master','')))

or is back-end:

if(match([Master Data],'EDM.EMEACust','EDM.CUSTOMER','EDM.LACust'),'Custome Master',IF([Master Data]='EDM.MTB','Vendor Master',IF([Master Data]='EDM.PTP','Finance Master',''))) as Group

[sasiparupudi1]

use a mapping load

map22:

Mapping LOAD * Inline

[

From,To

EDM.EMEACust,Customer Master

EDM.CUSTOMER,Customer Master

EDM.LACust,Customer Master

EDM.MTB,Vendor Master

EDM.PTP,Finance Master

];

LOAD *,ApplyMap('map22',YourField,'NA')as Result Resident mytable;