topic Re: Compare two tables in QlikView

Compare two tables

Fri, 28 Aug 2015 06:51:37 GMT

I have two tables, table A which contains order numbers and table B which should contain all order numbers too

but the case is that some numbers can be missing. How do I compare these two table? Can I get the missing one

in an own table or can I show them in a listbox?

kindly

Håkan

Re: Compare two tables

crusader_ — Fri, 28 Aug 2015 06:59:25 GMT

Hi,

You can achive your requirements in different ways.

See this post How Load tables like SQL minus

It helps you to find or flag missing rows from table B.

Regards,

Andrei

Re: Compare two tables

Fri, 28 Aug 2015 08:30:56 GMT

Hello again,

I looked to the example and I understand it, but in y case do I load the data from text files and I have problem to

convert the syntax from sql to Table files. How do I create the second table? My attempt doesn´t work. This is my code:

table1:

LOAD
@140:152 as Opus

FROM

(fix, codepage is 1252, header is 4 lines);

table2:

Load
Opus
where not exists(Opus);
LOAD @1 as Opus
FROM

(txt, codepage is 1252, no labels, delimiter is ' ', msq);

Re: Compare two tables

crusader_ — Fri, 28 Aug 2015 08:36:27 GMT

The error in this segment:

@140:152 as Opus

What does :152 mean?

Regards,

Andrei

Re: Compare two tables

Fri, 28 Aug 2015 08:52:57 GMT

Hello,

@140:152 is the positions in the textfile, this part works, I get table1 but not table2.

kindly

Håkan

Re: Compare two tables

crusader_ — Fri, 28 Aug 2015 08:57:46 GMT

Ehm...

why don't you use below syntax for table 2?

table2:
LOAD @1 as Opus
FROM

(txt, codepage is 1252, no labels, delimiter is ' ', msq)

where not exists(Opus);