How to join 2 cross tables

[silvia_assuncao]

Hi, I have 2 cross tables in my script and I need to join them, but the normal outer join is not working. coud anyone help me with that?

I'm attaching here my qvw and the spreadsheets loaded in the script as well

thanks

[Gysbert_Wassenaar · Accepted solution]

Concatenate the tables instead:

ResultTable:

CrossTable(Month, Value_AOP_LC, 12)

LOAD ...fields... FROM

     (ooxml, embedded labels, table is [AOP LC])

     ;

CONCATENATE (ResultTable)

CrossTable(Month, Actual_LC, 14)

LOAD ...fields... FROM

     (ooxml, embedded labels, table is [Act LC])

     ;