Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Load from Excel documents

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.

5 Replies
brenner_martina
Valued Contributor II

AW:Load from Excel documents

Hi Konstantinos,

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

Not applicable

AW:Load from Excel documents

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
Valued Contributor II

AW:Load from Excel documents

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
Valued Contributor II

AW:Load from Excel documents

for more details, see in my example

Not applicable

AW:Load from Excel documents

Thank you very much for the help!

Community Browser