combine a key-table with a calendar

[omyahamburg]

Hello all

I want to load from an existing table several fields as a key

Temp:
LOAD * INLINE [
field1, field2, field3

A, B, C

D, E, F
]

;

Table:
load field1&'/'&field2&'/'&field3 as key
resident Temp;
Drop Table Temp;

The result

A/B/C

D/E/F

I want to join with a calendar (01.01.2012 to 31.12.2012), so having at the end 730 data sets:

A/B/C	01.01.2012
A/B/C	02.01.2012
A/B/C	03.01.2012
A/B/C	04.01.2012
A/B/C	05.01.2012
A/B/C	06.01.2012
A/B/C	07.01.2012	etc
D/E/F	01.01.2012
D/E/F	02.01.2012
D/E/F	03.01.2012
D/E/F	04.01.2012
D/E/F	05.01.2012
D/E/F	06.01.2012
D/E/F	07.01.2012	etc

Can someone have an idea how to solve this ?

Thanks a lot.

Joerg

[Miguel_Angel_Baeyens]

Hello Joerg,

Take a look at the code in this post, very close to your needs.

Hope that helps.

Miguel

[omyahamburg]

Hello Miguel

That might solve my problem. I'll check both solutions.

Thanks a lot.

Joerg