Match data to load

[its_anandrjs]

Hi all,

I have query where i want to load matched data in the applicaion all i desribe in the application. Like i want to load a data for Aer, Cer, Vert like ways i have 200 around of data. I want to load only this three types of data now and i want to load that matched dataon the field Rets.

Aer

Cer

Vert

Please provide any help how to do that.

I put this on load of query after the load statement like Where Rets='Aer' and Rets='Cer' and Rets='Vert' but i have 300 of different records for Rets.

Anand

[klausskalts]

Try this:

Directory;

LOAD [Rets],

     Mins

FROM

TestData.xlsx

(ooxml, embedded labels, table is Sheet1)

where [Rets] = 'Aer' or [Rets] = 'Cer' or [Rets] = 'Vert'

;

[its_anandrjs]

Hi Klaus,

Thanks i do this thing but like  'Aer' or 'Cer' or 'Vert' i have 300 different types of values so in this case i have to type 300 different values like  [Rets] = 'Aer' or [Rets] = 'Cer' or [Rets] = 'Vert' in this code. Any other idea.

Regards,

Anand

[its_anandrjs]

Hi Klaus,

Suppose in my application there are 2000 types of [Rets] are loaded but i want to load only 300 types of [Rets] and this 300 are provided in excel file in a column and i want to load this 300 only. If want more information then i provide to all.

Regards,

Anand

[erichshiino]

Hi, Anand.

You can use the exists() as a condition.

First, load all the Rets values that you want to use as a condition:

ValidRets:

load Rets

From ValidRets.xlsx (ooxml, embedded labels, table is Sheet1); //YOU NEED TO CREATE THIS FILE

//THEN CHANGE THE CONDITION IN THE FOLLOWING LOAD

LOAD [Rets],

     Mins

FROM

TestData.xlsx

(ooxml, embedded labels, table is Sheet1)

where exists (Rets);

Hope this helps,

Erich

[its_anandrjs]

Hi Erich,

Thanks for suggestion now it is works i want to ask will it be work for n no of records like 1000, 10000, 100000 of records in excel file.

Regards,

Anand

[erichshiino · Accepted solution]

Sure

The exists is usually used for incremental reload. Sometimes we use it with millions of records.

Regards,

Erich