topic Re: Left Join between 2 QVD's in App Development

Left Join between 2 QVD's

dharis — Sat, 16 Nov 2024 17:52:27 GMT

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

Re: Left Join between 2 QVD's

ArnadoSandoval — Thu, 05 Nov 2020 10:37:33 GMT

Hi @dharis

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

Hope this helps,

Re: Left Join between 2 QVD's

dharis — Thu, 05 Nov 2020 13:46:51 GMT

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.

Re: Left Join between 2 QVD's

QFabian — Thu, 05 Nov 2020 13:54:50 GMT

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?