Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Could u plz see the attachment and tell me why year and month values are not visible.
Thanks,
AS
Try this script:
LOAD *,
month(Date) as Month,
year(Date) as Year;
LOAD Date#(Date, 'MMM DD, YYYY') as Date,
Name,
Revision
FROM
[2015-01-31-ecoReport.xlsx]
(ooxml, embedded labels, table is RawData);
These fields Show null values in the datamodel
try year(date#(Date,'MMM DD,YYYY'))
Try this script:
LOAD *,
month(Date) as Month,
year(Date) as Year;
LOAD Date#(Date, 'MMM DD, YYYY') as Date,
Name,
Revision
FROM
[2015-01-31-ecoReport.xlsx]
(ooxml, embedded labels, table is RawData);
this is the correct syntax for load:
LOAD Date,
month(Date#(Date, 'MMM DD, YYYY')) as Month,
year(Date#(Date, 'MMM DD, YYYY')) as Year,
Name,
Revision
FROM
....
PFA,