topic Merging two tables in QlikView

Merging two tables

Anonymous — Mon, 28 Dec 2009 20:42:28 GMT

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

Merging two tables

prieper — Mon, 28 Dec 2009 21:27:13 GMT

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

Peter

Merging two tables

Anonymous — Mon, 28 Dec 2009 21:53:28 GMT

Thx. Peter for your reply.

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

Greinier

Merging two tables

prieper — Tue, 29 Dec 2009 03:20:41 GMT

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