Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[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
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];
Thank you!