Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinni2000
Contributor III
Contributor III

Joining two qvds using inner join

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

1 Solution

Accepted Solutions
MayilVahanan

Hi

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. 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi

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. 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.