Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to load only the top10 Quarter Sales and need to do this in scripting .
Suggest me
find attached
Write condition as where rank <=10
You can derieve ranks by RANK() function.
Hi Martin,
that is not up to the requirement.
what we want is 2014(Q1-Q4) ,2013(Q1-Q4), 2012(Q3,Q4) as these are top 3 years and associated Quarters
we want only 10 Q's
don't understand.
the top years are 2014, 2013 and 2009
please define what quarters are wanted.
as you wrote top 3 years and 10 quarters, but one year is having 4 quarters = 12 quarters for 3 years
Hi,
I need to optimize my load I want to laod only 2014(Q1-Q4), 2013(Q1-Q4) and 2012(Q3,Q4)
these are maximum year Quarters. So, I need them
hope this time you understand a bit clear
So you need maximum year quarters irrespective of sales?
Temp:
LOAD Year,
Quarter,
Sales
FROM
[NEw.xlsx]
(ooxml, embedded labels, table is A, filters(
Replace(1, top, StrCnd(null))
));
NoConcatenate
Final:
First 10 Load * Resident Temp Order by Quarter Desc;
Drop table Temp;