Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am attaching the Sample app and go through it and
I need to have only 2014,2013 years data discarding other years data to reduce the reload time.
Suggestions on the same
Hi,
Try this script
LOAD
Floor(Year) AS Year,
Quarter,
Sales
FROM
[NEw.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Replace(1, top, StrCnd(null))
))
where match(Floor(Year), Year(Today()), Year(Today()) - 1) OR
(Floor(Year) = Year(Today()) - 2 AND Match(Quarter, Year(Today()) - 2 & 'Q3', Year(Today()) - 2 & 'Q4'));
Specify the filepath which is bolded in the above script.
Regards,
jagan.