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)
