Discussion Board for collaboration on QlikView Scripting.
Hello. I have 2 different excel documents. I want to load only the values from a column of the first document that are not on a specific column of the second document. Any help would be appreciated.
we need some more information! Can you upload an example?
Thanks for the reply.A simple example is the following.Let's say test1.xlsx has one column,column1 with values 1,2...30.The second document,test2.xlsx has one column,column2,with values 16,17...30.
I want qlikview to load only the values 1,2..15 from test1.xlsx, in other words the values that are not in column2.
you can use Exists function like this:
LOAD Column2 FROM test2.xlsx ...;
LOAD Column1 as Column2 FROM test1.xlsx
WHERE Not Exists (Column2, Column1);
for more details, see in my example
Thank you very much for the help!