Date conversion

[wilfredsj]

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.

[sunny_talwar]

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;

[sunny_talwar]

Or this

Date(MonthStart(Num#(Maand)), 'MMM YYYY') as Maand,

[Clever_Anjos]

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;

[wilfredsj]

‌Clever Anjos,

it’s works perfect, super!

thanks a lot.

WIlfred

[wilfredsj]

‌it works great!

thanks for the efforts

WIlfred