topic Re: PROBLEM WITH LEFT JOIN AND INNER JOIN in QlikView

PROBLEM WITH LEFT JOIN AND INNER JOIN

geogou1973 — Sat, 16 Nov 2024 00:10:31 GMT

Hello,

I have a problem with inner join or left join.

In the following script

LOAD ITEM,
QTY,
DATE,
STORE
FROM [F:\COUPONS.QVD] (qvd);

LEFT JOIN

LOAD STORE,
ITEM,
DATE,
AMOUNT
FROM [F:\SALES.QVD] (qvd);

in some cases the qty of coupons is doubled.

When from the script i remove the left join or inner join i have $Syn key that is DATE+STORE+ITEM and

the qty of coupons is correct but in this case i have all the data from the two tables and i want only the matching items from the two ones.

Why is this happening and how can i have correct data with inner join or left join because the number of rows are huge.

Can anyone help me ?

Thank you in advance.

Re: PROBLEM WITH LEFT JOIN AND INNER JOIN

Kushal_Chawda — Sun, 09 Aug 2020 18:12:32 GMT

try Keep

LOAD ITEM,
QTY,
DATE,
STORE
FROM [F:\COUPONS.QVD] (qvd);

LEFT keep

LOAD STORE,
ITEM,
DATE,
AMOUNT
FROM [F:\SALES.QVD] (qvd);

Re: PROBLEM WITH LEFT JOIN AND INNER JOIN

Vegar — Sun, 09 Aug 2020 18:25:05 GMT

Yes Keep could do the trick. @Kushal_Chawda used Left Keep, but Inner Keep is also a possible way depending on your data and what you are trying to achieve

Re: PROBLEM WITH LEFT JOIN AND INNER JOIN

geogou1973 — Sun, 09 Aug 2020 18:37:54 GMT

Hello Kush,

It is OK. Thank you.