Compare two tables

[#1]

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

[crusader_]

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

[#3]

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);

[crusader_]

The error in this segment:

     @140:152 as Opus

What does :152  mean?

Regards,

Andrei

[#5]

Hello,

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

kindly

Håkan

[crusader_]

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);