Decode Qlik query into Sql

Anonymous — Thu, 27 Sep 2018 12:04:32 GMT

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

topic Decode Qlik query into Sql in QlikView