topic Re: Fetch unmatched rows in QlikView

Fetch unmatched rows

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

I want fetch only unmatched values from two tables below,

and I want the output of unmatched values as shown below,

Please help,

Re: Fetch unmatched rows

vishsaggi — Thu, 25 May 2017 18:46:35 GMT

Try this may be?

Table1:

LOAD * INLINE [

DateField2, ID

5/17/2017, 1

5/18/2017, 2

5/19/2017, 3

5/20/2017, 4

5/21/2017, 5

];

Final:

LOAD * INLINE [

DateField1, ID

5/12/2017, 1

5/13/2017, 2

5/14/2017, 3

5/15/2017, 4

5/16/2017, 5

5/17/2017, 6

5/18/2017, 7

5/19/2017, 8

5/20/2017, 9

5/21/2017, 10

]

WHERE NOT Exists(DateField2, DateField1);

Drop Table Table1;

Drop Field DateField2;

Re: Fetch unmatched rows

trdandamudi — Thu, 25 May 2017 18:47:46 GMT

Load the small table first

Then load the big one with where condition:

Where not Exists(Date)

Re: Fetch unmatched rows

Anonymous — Thu, 25 May 2017 19:36:20 GMT

No, its not working Thirumala... Please suggest any other way.

Re: Fetch unmatched rows

trdandamudi — Thu, 25 May 2017 19:37:53 GMT

Table1:

LOAD * INLINE [
Date, ID
5/17/2017, 1
5/18/2017, 2
5/19/2017, 3
5/20/2017, 4
5/21/2017, 5
];

NoConcatenate
Final:

LOAD * INLINE [
Date, ID
5/12/2017, 1
5/13/2017, 2
5/14/2017, 3
5/15/2017, 4
5/16/2017, 5
5/17/2017, 6
5/18/2017, 7
5/19/2017, 8
5/20/2017, 9
5/21/2017, 10
]

WHERE NOT Exists(Date);

Drop Table Table1;

Re: Fetch unmatched rows

vishsaggi — Thu, 25 May 2017 19:59:46 GMT

Did you try my solution? Did it work ?

Re: Fetch unmatched rows

Anonymous — Thu, 25 May 2017 20:02:37 GMT

Yes I tried, but its not working.

Re: Fetch unmatched rows

vishsaggi — Thu, 25 May 2017 20:06:19 GMT

Strange. It worked at my end. You got what you want. That's good.

Re: Fetch unmatched rows

trdandamudi — Thu, 25 May 2017 23:37:16 GMT

Nagaraju, your code worked for me...