topic Re: Change Format Date Text to Number / Cambio Formato Fecha Texto a Número in QlikView

Change Format Date Text to Number / Cambio Formato Fecha Texto a Número

airobles — Wed, 25 Nov 2020 16:16:04 GMT

Hello ,

I have the following problem

How can I change the Format of a month, from Text to Number from the Load? I need it to be able to create the Weekday. Since in the loading file I have the three elements separated and the month arrives in text format.

Example:

JANUARY = 01

FEBRUARY = 02,

MARCH = 03

Thank you,

Note: Translation added by Community Moderator as a courtesy. Please use English in main forums.

- - -

Hola ,

Tengo el siguiente problema.

Como puedo cambiar el Formato de un mes, de Texto a Número desde el Load? Lo necesito para poder crear el Weekday. Ya que en el archivo de carga tengo los tres elementos separados y el mes llega en formato texto.

Ejemplo:

JANUARY = 01

FEBRUARY = 02,

MARCH = 03

Gracias,

Re: Cambio Formato Fecha Texto a Número

Digvijay_Singh — Tue, 13 Mar 2018 15:36:11 GMT

Do you mean you are receiving Month as 'JANUARY'? from your source?

You can have mapping table like this -

Map_Table:

Mapping Load

* inline [

MonthText,MonthNo

JANUARY,01

FEBRUARY ,02

...

];

Now in your load statement you can use Apply Map as

Applymap('Map_Table',YourMonthfield,'NA') as MonthNum

Re: Cambio Formato Fecha Texto a Número

airobles — Tue, 13 Mar 2018 16:08:33 GMT

Tanks Singh ! ,

It worked as wanted. now the field I can handle it

///

LOAD

MAKEDATE("[TIME].[TIME].[CALENDARYEAR].[MEMBER_CAPTION]",

Applymap('Map_Table',"[TIME].[TIME].[MONTHNUMBEROFYEAR].[MEMBER_CAPTION]",'NA'),

"[TIME].[TIME].[DAYNUMBEROFMONTH].[MEMBER_CAPTION]")

AS PERIODO,

///

Regards.

Re: Change Format Date Text to Number / Cambio Formato Fecha Texto a Número

MarcoWedel — Tue, 13 Mar 2018 23:51:12 GMT

Hi,

another solution might be;

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

table1:
LOAD *,
    Num(Month(Date#(MonthText,'MMMM')),'00') as Month
INLINE [
    MonthText
    JANUARY
    FEBRUARY
    MARCH
];

hope this helps

regards

Marco

Re: Change Format Date Text to Number / Cambio Formato Fecha Texto a Número

airobles — Thu, 15 Mar 2018 14:37:39 GMT

Tanks Marco!