Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Hi Konstantinos,

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

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Specialist II
Specialist II

for more details, see in my example

Highlighted
Not applicable

Thank you very much for the help!