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.
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.
