topic Re: Re: Display Common Records? in QlikView

Display Common Records?

Wed, 07 May 2014 19:02:57 GMT

Hi All

I Have 2 Table with 5 same fields, where F1 is Id it is unique in one table,but that id was not unique in another table.

Here: In Table1 For F5 there is only one F1.

In Table2 For F5 there will be more than one F1 . Now i need

The records of F1 and F5 for

1.The Common Records in both the tables

2.The Records those are not in table2 but in table1

3.The Records those are not in table1 but in table2

Please find the Attachment for data reference.

Thanks For Everyone.

Re: Display Common Records?

maxgro — Wed, 07 May 2014 19:14:00 GMT

Attachment ?

Re: Display Common Records?

Wed, 07 May 2014 19:16:18 GMT

Hi All

I Have 2 Table with 5 same fields, where F1 is Id it is unique in one table,but that id was not unique in another table.

Here: In Table1 For F5 there is only one F1.

In Table2 For F5 there will be more than one F1 . Now i need

The records of F1 and F5 for

1.The Common Records in both the tables

2.The Records those are not in table2 but in table1

3.The Records those are not in table1 but in table2

Please find the Attachment for data reference.

Thanks For Everyone.

Re: Re: Display Common Records?

Greg_Williams — Wed, 07 May 2014 19:59:01 GMT

Will this work for your desired solution?

-Greg

Re: Display Common Records?

Wed, 07 May 2014 20:06:12 GMT

May be like attached.

Thanks

Re: Re: Display Common Records?

Thu, 08 May 2014 08:33:58 GMT

Yes Greg.

Re: Display Common Records?

SunilChauhan — Thu, 08 May 2014 08:36:48 GMT

use inner join for common records

and

where not exists b/w two table for two times for not common records

Re: Display Common Records?

SunilChauhan — Thu, 08 May 2014 08:40:15 GMT

for common

Tab1:

Load

from table 1;

inner join

load

from table 2

for record in table2 but not in one

Tab2:

Load from Table1;

Tab3:

Load from table2 where not exists(table1Id,Table2ID);

drop table Tab2;

and just opposite for records in 1 but not in table 2

hope thishelps

Re: Display Common Records?

Greg_Williams — Thu, 08 May 2014 14:26:43 GMT

Great. Respectfully requesting > can you please mark this thread Helpful or Correct. Thanks.

Re: Display Common Records?

Fri, 09 May 2014 15:03:52 GMT

Hi Greg Sorry for late reply...

Its not use full for my scenario.