Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sonysree88
Creator II
Creator II

Same records

Hi Team,

I have 2 data sets 1 is A and another one is B

A: 1,2,3,  upto 10 millions record

B:1,2,3, ......10 millions of record.

I need to get the associated records from the both the data sets in to one resultant set.

 

Output:

A B

5  5

10 10

20 20

upto 10mils records

 

Regards,

Sunitha

Labels (1)
5 Replies
agni_gold
Specialist III
Specialist III

I need to get the associated records from the both the data sets in to one resultant set.

 

What do you mean by above, can you explain bit more on this ?

sonysree88
Creator II
Creator II
Author

I want to show the Same records from both the 2 data  sets There are no common fields but need to associate with common records

agni_gold
Specialist III
Specialist III

if we make it simple ,
you have 2 tables , A & B , you want another table C, in which common records from A & B should be there correct ?
anushree1
Specialist II
Specialist II

There are multiple ways to get it done like you may use Inner Join by renaming the field and having a condition basis the same, or probably use Exists Keyword, it depends on the kind of data you are dealing with , providing a sample input and desired output , will help to find what exactly you are looking for

sonysree88
Creator II
Creator II
Author

Hi Anushree,

Kindly let us know all the ways to get the result.