Hi Guru's,
I want to decode following query in Qlik into Oracle.planning to create DW table using following quey
if(WildMatch([SAPAddressID],'C0*')=1,
ApplyMap('SFAcctIDGadeaMap',
Text(EndClientID), 'Not Mapped to SALESFORCE_CUSTOMER_ID - Action Required'),
ApplyMap('SFAcctIDMap', Text(SAPAddressID), ApplyMap('SFAcctIDMap',
Text([Sales Customer]), ApplyMap('mapSALESFORCE_CUSTOMER_ID', Text([CRM Account Id]),
'Not Mapped to SALESFORCE_CUSTOMER_ID - Action Required'))))
Thanks,
rajiv