Scripting a List of values (year) into List of values (month)

[dennisthemenace]

Dear all,

following issue: I am having a crosstable which shows values per month. Now I want to concate another list, but unfortunatly its just a "normal" table showing the values in year. So, now  I would like to transform that list.

Following a sample how to tranform the normal table:

1) Status Quo:

Dimension 1   Dimension 2        Value (per year)

         ...                     ...                                120

2) How to transform:

Dimension 1   Dimension 2       Value (per month)

        ...                     ...                                 10

        ...                    ...                                  10 ..

Hope that there is someone who can help me without getting headach 🙂

Regards,

[marcus_sommer · Accepted solution]

Maybe in this way:

t: load dim1, dim2, value / 12 as value from source; join(t) load distinct month from calendar;

- Marcus