for... each loop ?

Fri, 09 Mar 2012 16:11:43 GMT

hi there,

i have the following problem: I have two tables:

IDs:

Months:

What i want:

For each ID in table IDs i want to create as many records as there are in table Months and in the end have one table that looks like this:

Result:

How can this be done in the LOAD script ?

Thanks a lot!

Fri, 09 Mar 2012 16:29:33 GMT

Hi,

I think that you can do this with a simple join statement.

Hope this helps, Ben

LOAD * INLINE [
    ID
    1
    2
    3
];

JOIN
Load * INLINE [
Month
201101
201102
201103
201104
201105
201106
];

topic for... each loop ? in QlikView