LEFT JOIN QLIK

congdat150599 — Fri, 09 Jul 2021 02:47:08 GMT

I have two tables, I want to join two tables together, but I have an error key, please help me!!!

FR04_T07_FORMAT:
LOAD
LIFNR AS FR04_T07_LFA1_KEY,
// BUKRS&BELNR&GJAHR AS FR04_T07_LFA1_KEY,
BUKRS&BELNR&GJAHR AS FR04_T07_BSAK_KEY,
LIFNR AS FR04_T07_LIFNR,
BUKRS&BELNR&GJAHR AS FR04_T07_REGUP_KEY,
SHKZG AS FR04_T07_SHKZG,
XANET AS FR04_T07_XANET
FROM [lib://ASAP_data (qlikserver-1_tamnguyen)/cjw@aufinia.com/QVD_DATA/Fi_Report/A_Fi_Report_BSAK.qvd]
(qvd);

LEFT JOIN (FR04_T07_FORMAT)
LOAD
LFA1_NAME1_BSEG AS FR04_T07_LFA1_NAME1_BSEG,
LFA1_KTOKK_BSEG AS FR04_T07_LFA1_KTOKK_BSEG,
BSEG_LIFNR AS FR04_T07_LFA1_KEY
FROM [lib://ASAP_data (qlikserver-1_tamnguyen)/AufiniaQ/QVD_DATA/B_PHASE/B_SS01_08_IT_BSEG_BKPF.qvd]
(qvd);

Re: LEFT JOIN QLIK

avinashelite — Fri, 09 Jul 2021 03:34:42 GMT

What is the error your getting , could you add more infor

Re: LEFT JOIN QLIK

congdat150599 — Fri, 16 Jul 2021 09:09:56 GMT

Thanks, Avinashelite, My problem was solved.

topic Re: LEFT JOIN QLIK in Search the Community

LEFT JOIN QLIK

Re: LEFT JOIN QLIK

Re: LEFT JOIN QLIK