Load from Excel documents

[#1]

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.

[brenner_martina]

Hi Konstantinos,

we need some more information! Can you upload an example?

[#3]

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.

Thank you

[sparur]

Hello,

you can use Exists function like this:

LOAD Column2 FROM test2.xlsx ...;

LOAD Column1 as Column2 FROM test1.xlsx

WHERE Not Exists (Column2, Column1);

[sparur]

for more details, see in my example

[#6]

Thank you very much for the help!