topic Match data to load in QlikView

Match data to load

its_anandrjs — Fri, 12 Aug 2011 13:14:25 GMT

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

Match data to load

klausskalts — Fri, 12 Aug 2011 13:42:01 GMT

Try this:

Directory;

LOAD [Rets],

Mins

FROM

TestData.xlsx

(ooxml, embedded labels, table is Sheet1)

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

;

Match data to load

its_anandrjs — Fri, 12 Aug 2011 13:50:21 GMT

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

Match data to load

its_anandrjs — Fri, 12 Aug 2011 14:01:15 GMT

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

Match data to load

erichshiino — Fri, 12 Aug 2011 15:31:24 GMT

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

Match data to load

its_anandrjs — Fri, 12 Aug 2011 18:48:12 GMT

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

Match data to load

erichshiino — Fri, 12 Aug 2011 19:09:23 GMT

Sure

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

Regards,

Erich