Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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
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;