Relaod Time

[Anonymous]

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

[jagan]

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.