Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends ,
I have two columns , like
Hours worksoft.hours
---------------------------------------------------------
orderning35,5 timelon 37,5
orderning37,5 timelon 35,5
I need Output like this :
Hours worksoft.hours
---------------------------------------------------------
orderning35,5 timelon 35,5
orderning37,5 timelon 37,5
Can Anyone help me how to sort
Thanks inAdvace
Janardhanreddy
Hi Janardhan,
Try this script below
Temp:
LOAD * INLINE [
Hours1,Hours2
"orderning35,5", "timelon 37,5"
"orderning37,5", "timelon 35,5"
];
Test:
LOAD
RowNo() AS RowNo,
Hours1
RESIDENT Temp
ORDER BY Hours1;
Test2:
LOAD
RowNo() AS RowNo,
Hours2
RESIDENT Temp
ORDER BY Hours2;
DROP Table Temp;
Hope this is what you are expecting.
Regards,
Jagan.