Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wilfredsj
Contributor II
Contributor II

Date conversion

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.

5 Replies
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
Employee
Employee

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
Contributor II
Contributor II
Author

‌Clever Anjos,

it’s works perfect, super!

thanks a lot.

WIlfred

wilfredsj
Contributor II
Contributor II
Author

‌it works great!

thanks for the efforts

WIlfred