How to join 2 cross tables

silvia_assuncao — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to join 2 cross tables

Gysbert_Wassenaar — Thu, 30 Jun 2016 16:16:22 GMT

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

;