Convert SQL into Qlikview

zwyne — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

PFA,

I would like to convert the attached SQL query into Qlikview

Re: Convert SQL into Qlikview

ikarimov — Wed, 14 Aug 2019 12:12:48 GMT

hello, qlikview can load this query as is, or you can split this request into several separate ones and let the software bind data by fields:

qualify *;

unqualify Cust_Key,Account_Number;

lake_cust_all:

select * from lake_cust_all;

lake_cust_acc_prod:

left keep (lake_cust_all)

select * from lake_cust_acc_prod;

lake_txn_Summary:

left keep (lake_cust_acc_prod)

select Account_number,Product,NoofTxn from lake_txn_Summary;

and third metod - store data or this tables into qvd layer and use it as source in second metod (I advise you to do so)