Joining two qvds using inner join

Vinni2000 — Mon, 08 May 2023 08:54:48 GMT

I want join two qvds using inner joining so I have two common fields between two tables those are order_number and item_number

Re: Joining two qvds using inner join

MayilVahanan — Mon, 08 May 2023 09:34:27 GMT

Just do the inner join, it will reflect based on both fields.

Load * from QVD1.qvd(qvd);
Inner join
Load * from QVD2.qvd(qvd);

Suppose if you want to do based on one field alone, then rename one of the field.

topic Re: Joining two qvds using inner join in QlikView

Joining two qvds using inner join

Re: Joining two qvds using inner join