Order By on Resident table not working

[alandilworth]

I'm trying to load a new sorted table from a resident table and my Order By condition is not working.  My load script is below.  Any insight will be greatly appreciated!  I'm stumped to why this is not working

[0 to 6 months]:
NoConcatenate LOAD
[Owner],
[Territory],
sum(AllTimeMegaSales)
Resident [0 to 6 months temp]
group by [Owner],[Territory];

[0 to 6 months sorted]:
NoConcatenate LOAD
[Owner],
[Territory],
[AllTimeMegaSales]
Resident [0 to 6 months]
order by [AllTimeMegaSales] ASC;

[GaryGiles · Accepted solution]

I think you need to rename sum() field in your first load with AS clause.  Otherwise, the field name is sum(AllTimeMegaSales).

[0 to 6 months]:
NoConcatenate LOAD
[Owner],
[Territory],
sum(AllTimeMegaSales) as AllTimeMegaSales
Resident [0 to 6 months temp]
group by [Owner],[Territory];

[0 to 6 months sorted]:
NoConcatenate LOAD
[Owner],
[Territory],
[AllTimeMegaSales]
Resident [0 to 6 months]
order by [AllTimeMegaSales] ASC;