Cross Table

[Anonymous]

[Kostenstellkosten]:

CrossTable(Month, Kosten,2)

LOAD [Kostenstelle],

[Kostenart],

[43009],

[43040],

[43070],

[43101],

[43132],

[43160],

[43191],

[43221],

[43252],

[43282],

[43313],

[43344]

FROM [lib://AttachedFiles/KostenSAP.xlsx]

(ooxml, embedded labels, table is Kostenstellkosten);

Final:

Load Kostenstelle,

date(num#(purgeChar(Month,'"'),'00000')) as Month,

         Kosten,

Kostenart

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

Could you please explain, why my file is not uploaded in this format? If i upload it without 'Kostenart' (see below), it is working, In my Final File i would like to more than just Kostenstelle, Kosten & Month.

Final:

Load Kostenstelle,

date(num#(purgeChar(Month,'"'),'00000')) as Month,

         Kosten,

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

Thank you in advance

[sunny_talwar]

Try this

[Kostenstellkosten]:

CrossTable(Month, Kosten,2)

LOAD [Kostenstelle],

[Kostenart],

[43009],

[43040],

[43070],

[43101],

[43132],

[43160],

[43191],

[43221],

[43252],

[43282],

[43313],

[43344]

FROM [lib://AttachedFiles/KostenSAP.xlsx]

(ooxml, embedded labels, table is Kostenstellkosten);

Final:

NoConcatenate

Load Kostenstelle,

          date(num#(purgeChar(Month,'"'),'00000')) as Month,

        Kosten,

          Kostenart

Resident [Kostenstellkosten];

Drop Table [Kostenstellkosten];

[Anonymous]

Thank you!