How to convert the num into Date

[#1]

Hi All,

I have the following excel, which includes the YearMonth, but when I load the it into QV, it shows the Int format, could you help me on how to convert it into Date by

script?

I have attached the Excel file and QVW as attached, could you help me out?

Thanks.

[kaushiknsolanki · Accepted solution]

Try this.

TestTable:

CrossTable(YearMonth, Revenue)
LOAD Region,
     [40452],
     [40483],
     [40513],
     [40544]
FROM
Test.xlsx
(ooxml, embedded labels, table is Sheet1);

NoConcatenate
Load MonthName((num#(YearMonth))) as YearMonth1,Revenue,Region Resident TestTable;

drop table TestTable;

Regards,

Kaushik Solanki

[er_mohit]

See the attached file

A:

CrossTable( Date,Value)

LOAD Region,

    [40452]  ,

     [40483],

     [40513],

   [40544]

FROM

(ooxml, embedded labels, table is Sheet1);

B:

LOAD Region as REGION,Value AS VALUE, dATE(Num#(Date)) AS DATE

Resident A;

DROP Table A;