Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dharis
Contributor III
Contributor III

Left Join between 2 QVD's

Hi All, 

Trying to use LeftJoin() and get required column between 4 QVD's,

1.below is the script and error message (BOLD). Kindly help. 

 

Main:
LOAD * FROM [lib://OB_QVD (asiapacific_dharis)/OB_COM_MAIN.qvd]
(qvd);

Left Join

LOAD
"SNP Process Calendar Date DD MM YYYY Code",
PROFIT_CENTER_L1_NAME,
EGNetUSDAmount

FROM [lib://OB_QVD (asiapacific_dharis)/OB_COM_FINANCE.qvd]
(qvd);

Store * from [Main] into [lib://OB_QVD (asiapacific_dharis)/OB_COM_FINAL.qvd]
(qvd);

SAP_SOLI  is the unique column between QVD's

Lines fetched: 10
1:08:40 PM
Table 'Main' not found: Store * from [Main] into [lib://OB_QVD (asiapacific_dharis)/OB_COM_FINAL.qvd] (qvd)
1:08:54 PM
$Syn 1 = SAP_SOLI+SNP Process Calendar Date DD MM YYYY Code+PROFIT_CENTER_L1_NAME+EGNetUSDAmount
Labels (1)
3 Replies
ArnadoSandoval
Specialist II
Specialist II

Hi @dharis 

I suggest you to implement Mapping Load  with ApplyMap - script function  

Hope this helps,

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.
dharis
Contributor III
Contributor III
Author

Issue addressed.. Got the left join working.. Thank you ALL.. 

Hi ArnadoSandoval,  Thank you for your reply but, understand Apply Map works with limited columns right.. so my table as multiple columns to Join. 

QFabian
Specialist II
Specialist II

Please check :

1.- Perhaps you have another 'Main' table before, so the 'Main' you show could be 'Main-1' ?

2.- took of the [] 

3.-Maybe your 'Main' table doesnt exists, and their data concatenated autmatically to another existing table?

QFabian