sorting

[janardhan]

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

[jagan]

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.