topic Re: Same records in QlikView

Same records

sonysree88 — Sat, 16 Nov 2024 21:31:40 GMT

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

Re: Same records

agni_gold — Mon, 28 Jan 2019 06:46:28 GMT

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 ?

Re: Same records

sonysree88 — Mon, 28 Jan 2019 06:48:44 GMT

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

Re: Same records

agni_gold — Mon, 28 Jan 2019 06:53:21 GMT

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 ?

Re: Same records

anushree1 — Mon, 28 Jan 2019 07:23:55 GMT

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

Re: Same records

sonysree88 — Mon, 28 Jan 2019 08:30:44 GMT

Hi Anushree,

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