topic How can we iterate using for loop to read records from Inline Loaded data in QlikView

How can we iterate using for loop to read records from Inline Loaded data

Fri, 30 Apr 2010 12:52:30 GMT

Hi All,

Can you please suggest me the way to iterate using for loop to read records from Inline data?

Thanks

fernandotoledo — Fri, 30 Apr 2010 13:13:57 GMT

I didn´t get exactly what you are trying to do, but the loop works this way:


for i=0 to 10
load $(i) as iteration,*;
load * inline [
DATA,
a,
b,
c,
d,
e
];
next

Search the autogenerate function in help, that should work fine too!

best regards,

Fernando D'Agosto

Fri, 30 Apr 2010 13:14:40 GMT

Sanjay

Why would you want to execute a loop on an inline load? I don't understand the reason you would need to do this.

A load inline would normally list all of the records to load immediately after the LOAD INLINE statement, such as:

LOAD * INLINE
Field1,Field2,Field3
a,bb,231
c,ee,819
a,ff,473
];

Can you give more information.

Fri, 30 Apr 2010 13:38:12 GMT

Hi Nigel,

Thank you for your quick response.

Actually i want to automate reloading of some qvd files and i will also want incremental loading of data into those qvd files.

For this, i can save name of tables, primary key and qvd file names in .csv file or as inline data.

After that i want to iterate through those tables for incremental loading based on the primary key and last modification date saved in qvd file.

Please suggest if i can do the same using different approach.

Thanks,

Sanjay