topic Re: Retrieving information-unique data comparing 2 tables in QlikView

Retrieving information-unique data comparing 2 tables

Fri, 05 Jul 2013 11:35:58 GMT

Hi,

Could anybody assist wtih this issue I have ?

How can I retrieve unique information from 2 resident tables. I only want what is still unique do table 2

Table 1

Column 1 | Column 2 | Column3

20130601 | 'Jam' | Serial N. 2233

20130610 | 'Milk' | Serial N. 2234

Table 2

Column 1 | Column 2 |

2233 | 'Produce' |

2234 | 'Produce' |

2235 | 'Produce' |

2236 | 'Produce' |

What I want is to retrieve 2235 and 2236 from Table 2. Thanks in advance.

Rui

Fri, 05 Jul 2013 11:48:37 GMT

hi,

use exists function.

syntax:

Load * [source] where not exists (<current table field to check>,<already loaded field to check>);

Niranjan M.

Fri, 05 Jul 2013 13:07:00 GMT

Niranjan,

So would this be something like:

load * resident Table2 where not exists (Table.Column2, Table1.Column3);?

Fri, 05 Jul 2013 13:32:54 GMT

Hi thanks for your reply.

Ok,

I used 2235 and 2236 as example. There are plenty ID that require selection.

Fri, 05 Jul 2013 14:16:38 GMT

Attached the QVW which will get the unique records from 2 tables.

Gysbert_Wassenaar — Fri, 05 Jul 2013 14:21:56 GMT

See attached example.

Fri, 05 Jul 2013 14:51:12 GMT

Hi Guys,

Thanks a million!! That solves it.