topic AW:Load from Excel documents in QlikView

Load from Excel documents

Wed, 30 Jun 2010 08:23:43 GMT

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.

AW:Load from Excel documents

brenner_martina — Wed, 30 Jun 2010 08:30:00 GMT

Hi Konstantinos,

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

AW:Load from Excel documents

Wed, 30 Jun 2010 08:37:18 GMT

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

AW:Load from Excel documents

sparur — Wed, 30 Jun 2010 08:40:10 GMT

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);

AW:Load from Excel documents

sparur — Wed, 30 Jun 2010 08:43:16 GMT

for more details, see in my example

AW:Load from Excel documents

Wed, 30 Jun 2010 08:48:29 GMT

Thank you very much for the help!