topic Re: How to exclude data from Excel file in QlikView

How to exclude data using Excel file

dhananjay_capge — Fri, 05 Jun 2015 11:44:09 GMT

Test

Anonymous — Fri, 05 Jun 2015 11:50:08 GMT

what do you mean by execute ? do you want to load data from excel with some where condition ?

Thanks

BKC

fvelascog72 — Fri, 05 Jun 2015 11:50:43 GMT

Hi,

If you don´t want to load some Investment_Name from excel, you can use where not exists.

dhananjay_capge — Fri, 05 Jun 2015 12:00:29 GMT

Hi Balkumar,

As Federico said i want to exclude this Investment name with respective calendar key which is present in a Excel file..

We can use Where Not Exists function but it not works may be my syntax is incorrect..

Could you please suggest me how to write this where not exits in script if possible.

THanks,

Djadhav

Anonymous — Fri, 05 Jun 2015 12:09:31 GMT

First you need to load your excel into qliview then use that column in where Not Exists()

ex .

Load Name

From Excel1

Load

Name,

Address

from .....table2

where Not Exists(Name)

Note : you should have Name column in both the table

see the example for syntax