Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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;