for... each loop ?

[#1]

hi there,

i have the following problem: I have two tables:

IDs:

ID
1
2
3

Months:

Month
201101
201102
201103
201104
201105
201106

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:

ID	Month
1	201101
1	201102
1	201103
1	201104
1	201105
1	201106
2	201101
2	201102
2	201103
2	201104
2	201105
2	201106
3	201101
3	201102
3	201103
3	201104
3	201105
3	201106

How can this be done in the LOAD script ?

Thanks a lot!

[#2 · Accepted solution]

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
];