Subfield with Rank

[#1]

Hi All,

I have data like below

String	Number
A-B	100-200
C-D	300-500
E-F	250-200

I want the output like below'

String	Number	Rank
D	500	1
C	300	2
E	250	3
B	200	4
F	200	4
A	100	5

Note: I want to do it in script

[Kushal_Chawda · Accepted solution]

try this

Data:

LOAD subfield(String,'-',1) as String,

     subfield(Number,'-',1) as Number

FROM TABLE;

LOAD subfield(String,'-',2) as String,

     subfield(Number,'-',2) as Number

FROM TABLE;

Final:

noconcatenate

LOAD *,

     if(Rowno()=1,1,

     if(Number = previous(Number), peek('Rank'),peek('Rank')+1)) as Rank

Resident Data

order by Number Desc;

Drop Table Data;

Edit: Drop table stmt added

[swuehl]

Or

INPUT:

LOAD Subfield(String,'-',iterno()) as Name, Subfield(Number,'-',iterno()) as Value

WHILE iterNo() <=2;

LOAD * INLINE [

String, Number

A-B, 100-200

C-D, 300-500

E-F, 250-200

];

RESULT:

LOAD *, AutoNumber(Value) as Rank

Resident INPUT

Order by Value desc;

DROP table INPUT;

[dusasuman]

Hi,

Please find the attached qvw file. Rank would be the result of Rowno() function when we load the table with Descending order.

Hope it helps..

Regards

Suman