Loading Cross Table with NUM#

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

Dear All,

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

thank you in advance

topic Loading Cross Table with NUM# in QlikView

Loading Cross Table with NUM#