This content has been marked as final. Show 4 replies
PFA the test data (a single column) that is not getting sorted when we write the following code:
(biff, embedded labels, table is Sheet1$);
load distinct * Resident D
Order by x;
drop Table D;
I know that Order By executes before Load. Thus accordingly, Load Distinct should be applied on the sorted column x which should in turn return the sorted Distinct values.
It would be really helpful if you could help me tell why it is not getting sorted.