I have loaded the cross table and thought converted text strin into a numeric field, but somehow fields from other tables are not associated correctly? What is the point I am missing?
here is the script:
LOAD Kostenstelle,
Periode,
FY,
[Menge erfaßt gesamt]
FROM
(ooxml, embedded labels, table is [2017]);
LOAD Kostenstelle,
Periode,
FY,
[Menge erfaßt gesamt]
FROM
(ooxml, embedded labels, table is [2018]);
LOAD Kostenstelle,
Objektbezeichnung
FROM
(ooxml, embedded labels, table is Abt);
CrossTable(Perio, FTE)
LOAD Kostenstelle,
[1],
[2],
[3],
[4],
[5],
[6],
[7],
[8],
[9],
[10],
[11],
[12]
FROM
(ooxml, embedded labels, table is MA);
MA:
load Num# (Perio) as Periode
Resident MA;
I would like to achieve that Perio is associated with the field Periode
