union different dimension with same names

[#1]

Hello everyone,

I have the following problem:

I have 2 straight table charts:

1) Dimension: moth name of "claim_started" from a table

    Expression: sum(amount_eur)

2) Dimension: month name of "reserve_date" from another table

    Expression: sum(reserve_eur)

What I would like to do is to union somehow this 2 tables, because the dimension names are the same (Jan,Feb,Mar...) even if they refer to different date fields and to keep the Expressions values identically...

EX:

1)

month(claim_started)   Value1

Jan                             134

Feb                             12

Mar                             23

...                               ...  

2)

month(reserve_date)   Value2

Jan                         33

Feb                         544

Mar                         44

...

And the result table must look like:

month     Value1     Value2

Jan          132          33

Feb          12            544

Mar          23            44

...

Thank you very much,

Silviu

[#2]

You could try creating a master calendar, linking the main table by claim_started and then resident load the same table and link it to the master calendar by reserve_date

[mphekin12]

You could use a JOIN statement.  Something like the following should work for you:

tblTest:

LOAD * INLINE [
Month, Value1
Jan, 134
Feb, 12
Mar, 23
];


JOIN
LOAD * INLINE [
Month, Value2
Jan, 33
Feb, 544
Mar, 44
];

[Anonymous · Accepted solution]

Hi Silviu,

Find attached an example document on how to create a link table with a mastercalendar. This will solve the problem for you.

Kind regards,

Henco

[#5]

Thank you all for you're help.

I will try to use you're solution, and if it still won't work, I'll post back.

Best regards,

Silviu.

[Anonymous]

Oké, good luck. Would you please mark the answers as helpful or correct please

Kind regards,

Henco