Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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