Hi Experts,
I have a requirement like I want to convert the Qlik Data model into a query. since Qlik Doesn't gives a query, I manually trying to convert the existing script into a Query.
Now I got a requirement like Applymap needs to be replace with IF else or case statement.
if we have only one argument we in applymap we can simply write it. But i have nested applymap in nested If condition.
below is the code.
if(OPERATING_UNIT_NAME = 'Grafton OU',
ApplyMap('CDBGBusinessUnitMap', Num#(CUSTOMER_TRANSACTION_NUMBER) ,
If(BATCH_SOURCE_NAME = 'PROJECTS INVOICES' AND NOT(IsNull(ACCT_BU)), ApplyMap('TaskOrgBUMap', ACCT_BU, ACCT_BU), ApplyMap('BusinessUnitMapInvoice',BusinessUnitID, 'Other'))),
If(BATCH_SOURCE_NAME = 'PROJECTS INVOICES' AND NOT(IsNull(ACCT_BU)), ApplyMap('TaskOrgBUMap', ACCT_BU, ACCT_BU), ApplyMap('BusinessUnitMapInvoice',BusinessUnitID, 'Other'))
)
Please help me on this.
