Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Decode Qlik query into Sql

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

0 Replies