I 'm having a problem. I want to sort numeric data (Smallest to Largest).
row A, B, C
1 4, 8, 2
2 2, 5, 1
?(A,B,C) Return 248 (row 1)
?(A,B,C) Return 125 (row 2)
What a function to solve this?
Thanks for any help.
You use the Rank function in Order. You see Guide.
Could you please give me example or QVW file?
Sorting the column is possible only with resident load not directly on files.
So load the file and use order by in resident load.
Load * from test .xlx;
Load * from resident Tab1 order by Column_name asc/desc; ( silmilar to sql order by)
Thanks Sivaraj Seeman,
But I want to sort by row and concatenate to new value.
Try to create a sample app with inline data and share here explaining expected output.
This QVW File for explain my expect output.
One way could be like attched sample.
What logic are you using to transform the data.
If 312 is to be transformed as123 then how 488 remains unchanged and 991 changed to 199
Because 312 sort by ascending order = 123
488 sort by ascending order = 488
991 sort by ascending order = 199
Retrieving data ...