Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
error description:Invalid expression
ProductDates:
LOAD
Max(Dates))as MaxDate,
Dates as allDates
FROM
[..\Data Files\Excel\ProducSoldDates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Cant we define script in this way, why is it failing to load as columns?
Try this
ProductDates:
LOAD Dates as allDates
FROM
[..\Data Files\Excel\ProducSoldDates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Join (ProductDates)
LOAD Max(Dates) as MaxDate
Resident ProductDates;
Try this
ProductDates:
LOAD Dates as allDates
FROM
[..\Data Files\Excel\ProducSoldDates.xlsx]
(ooxml, embedded labels, table is Sheet1);
Join (ProductDates)
LOAD Max(Dates) as MaxDate
Resident ProductDates;
thanks, can you explain the actual problem?
You cannot load Max(Dates) and Dates in a same table... because when you use an aggregation function such as Sum, Max, Min... etc... you need a Group By statement which include non-aggregating fields.... if you add Group By Dates... then Max(Dates) will essentially show the same Date for each Date
That is why you need to divide it into two pieces....
Does that make sense?