Left Join between 2 QVD's

[dharis]

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

[ArnadoSandoval]

Hi @dharis 

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

Hope this helps,

[dharis]

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]

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?