Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
As starter cannot get de date conversion into the tabel:
VastOpFunctie:
Crosstable (Maand, OpFunctie)
LOAD PersoonsID,
"42909",
"42939",
"42970",
"43001",
"43031",
"43062",
FROM [lib://qlikid_wilfredsj/test.xlsx]
(ooxml, embedded labels, table is Blad1)
Want I want is convert "42909" to month, Year
I figure out i should be Date(Maand,'MMM YYYY') as Maand but where to place it in the script?
So that the "maand" column holds march 2017 in stead of 42909" ...
I would really appreciate is someone can provide me the right script.
Try this
VastOpFunctie:
Crosstable (Maand, OpFunctie)
LOAD PersoonsID,
"42909",
"42939",
"42970",
"43001",
"43031",
"43062",
FROM [lib://qlikid_wilfredsj/test.xlsx]
(ooxml, embedded labels, table is Blad1)
FinalTable:
NoConcatenate
LOAD PersoonsID,
Date(Num#(Maand), 'MMM YYYY') as Maand,
OpFunctie
Resident VastOpFunctie;
DROP Table VastOpFunctie;
Or this
Date(MonthStart(Num#(Maand)), 'MMM YYYY') as Maand,
Try this
VastOpFunctie:
Crosstable (Maand, OpFunctie)
LOAD PersoonsID,
"42909",
"42939",
"42970",
"43001",
"43031",
"43062",
FROM [lib://qlikid_wilfredsj/test.xlsx]
(ooxml, embedded labels, table is Blad1);
Noconcatenate
load
PersoonsID,
Date(Trim(Maand),'MMM/YYYY') AS Maand,
OpFunctie
Resident VastOpFunctie;
drop table VastOpFunctie;
Clever Anjos,
it’s works perfect, super!
thanks a lot.
WIlfred
it works great!
thanks for the efforts
WIlfred