Crosstable multiple fields

[G3S]

hi,

Dataset has 3 dates from which week + year are derived. 

I've created cross tables  for week and year separately - (so user is able select only the week number and all applicable details can be filtered for that particular week number/Year in all three dates.)

is there a way to combine the WeekNumber, Year fields to be in a single table? (there is additional data which is available at week/year level that needs to be joined - based on the week-year combination in the cross table)

appreciate the help to have WeekNumber and Year in one final table..with the associated BkdTEU & TEUperPO_OrderLine per OrderNo?

below is the crosstable script + the addl data to be joined.

------

tmpData:
Crosstable (WeekType,WeekNumber)

LOAD OrderNo,
Week_UpdatedReqdShipDate,
Week_MaxShipmentShipDate,
Week_MaxATD

Resident OrderData0
;

Final:
Load
OrderNo,
WeekType as Type,
WeekNumber

Resident tmpData;

Drop Table tmpData;

macaroon:

LOAD
OrderNo,
BkdTEU,
TEUperPO_OrderLine

Resident OrderData0
;

drop table macaroon
;

tmpData_Year:
Crosstable (YearType,Year)

LOAD OrderNo,
Year_UpdatedReqdShipDate,
Year_MaxShipmentShipDate,
Year_MaxATD

Resident OrderData0
;

Final_Year:
Load
OrderNo,
YearType as TypeYear,
Year

Resident tmpData_Year;

Drop Table tmpData_Year;

macaroon_Year:

LOAD
OrderNo,
BkdTEU,
TEUperPO_OrderLine

Resident OrderData0
;

drop table macaroon_Year
;

//additional data to be added

Forecast:
LOAD

Origin,
Destination,
WeekNumber,
"Calendar Year"
ForecastTEU,

FROM [lib://QVD Prod Files/ v6.xlsx]
(ooxml, embedded labels, table is Sheet1);