How to sort numeric by function in script?

[maxloveiii]

     I 'm having a problem. I want to sort numeric data (Smallest to Largest).

Example.

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.

[antoniotiman]

You use the Rank function in Order. You see Guide.

Regards

[sivarajs]

Sorting the column is possible only with resident load not directly on files.

So load the file and use order by in resident load.

Tab1:

Load * from test .xlx;

Tab2:

Load * from resident Tab1 order by Column_name asc/desc; ( silmilar to sql order by)

[maxloveiii]

Could you please give me example or QVW file?

[maxloveiii]

Thanks sivarajs

But I want to sort by row and concatenate to new value.

[tresesco]

Try to create a sample app with inline data and share here explaining expected output.

[maxloveiii]

This QVW File for explain my expect output.

[tresesco · Accepted solution]

One way could be like attched sample.

[#9]

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

[maxloveiii]

Because  312 sort by ascending order = 123

               488 sort by ascending order = 488

               991 sort by ascending order = 199