How to exclude data using Excel file

[dhananjay_capge]

Test

[Anonymous]

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

Thanks

BKC

[fvelascog72]

Hi,

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

[dhananjay_capge]

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]

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

ex .

A:

Load Name

From Excel1

B:

Load

Name,

Address

from .....table2

where Not Exists(Name)

Note : you should have Name column in both the table

see the example for syntax

Dual & Exists – Useful Functions