topic Looping while loading the data in QlikView

Looping while loading the data

Fri, 08 Nov 2013 12:11:57 GMT

I want to load the data within a loop. The following is my case,

General logic:

my_data:

ResultSet resultSet = "Select distinct designation, location from employee";

for(int i = 0; i < resultSet.count; i++) {

load emp_id,

name,

designation, location, salary;

sql select * from employee where location = "resultSet.location" , designation = "resultSet.designation";

}

I want the above logic should be done while loading the data. Every time it should concatenate/append with the existing data.

Please help me to get this done.

Re: Looping while loading the data

annafuksa1 — Fri, 08 Nov 2013 12:20:30 GMT

can you attach a file ?

Re: Looping while loading the data

Fri, 08 Nov 2013 12:23:08 GMT

Hi Rajaram,

"For next" as well as "For each next" is described with examples in the reference manual. If you have done a full installation of QlikView you can find it here :

C:\ProgramData\QlikTech\QlikView Documentation\Reference Manual

/Ida

Re: Looping while loading the data

jonathandienst — Fri, 08 Nov 2013 12:51:42 GMT

I think this is what you are looking for:

tmpLocationDesignation:

LOAD Distinct

Location,

Designation

From employee;

For i = 1 To NoOfRows('tmpLocationDesignation')

Let zLocation = Peek('Location', i, 'tmpLocationDesignation');

Let zDesignation = Peek('Designation', i, 'tmpLocationDesignation');

my_data:

load emp_id,

name,

designation,

location,

salary;

sql select * from employee

where location = '$(zLocation)' And designation = '$(zDesignation)';

Next

Set zLocation =;

Set zDesignation =;

Drop Table tmpLocationDesignation;

HTH

Jonathan