Merging two tables

[Anonymous]

Hello,

Maybe I have a simple problem. But I cannot solve this.

I would like to merge 2 files.

The first one is a file with transactionhistory and per record Item-info. The second one is the current Itemfile.

Both are reachable by SQL-commands.

I would like to extract the Iteminfo from the first file which is not in the second file. And together it has to be a new file which can be used in Qlikview.

In the transactionhistory itemdata exists more than once for one item.

Thanks in advance.

Kind regards,

Greinier

[prieper]

As fast solution: JOIN the both tables (common field is Item) and filter for NULL-values.

Peter

[Anonymous]

Thx. Peter for your reply.

I will try this but can I filter the NULL-values in the code ??

Greinier

[prieper]

Within the script is no problem, you have the ISNULL()-function, but better would be to use a construct like LEN(Item) = 0 as 64-bit-system do not recognize Null-values.

HTH
Peter