How to number rows for given records in script and filter only once occuring record using set expression ?

[prahlad_infy]

Hi All ,

How to number rows for given records in script ?

And set expression to filter below data as its occur only once 

Panacea

ABO24

1

Input Data :

Feature	Rand_Text
Temperate Forest	ABO1
Amazon Rainforest	ABO10
Hawana	ABO11
Grassland	ABO12
Temperate Forest	ABO13
Tropical	ABO14
Temperate Forest	ABO15
Amazon Rainforest	ABO16
Grassland	ABO18
Torrential Rain	ABO19
Torrential Rain	ABO2
Tropical	ABO20
Temperate Forest	ABO21
Amazon Rainforest	ABO22
Panacea	ABO24
Torrential Rain	ABO25
Tropical	ABO26
Temperate Forest	ABO27
Amazon Rainforest	ABO28
Hawana	ABO29
Temperate Forest	ABO3
Amazon Rainforest	ABO4
Hawana	ABO5
Grassland	ABO6
Temperate Forest	ABO7
Tropical	ABO8
Temperate Forest	ABO9

Output 

Feature	Rand_Text	Numbering
Amazon Rainforest	ABO4	1
Amazon Rainforest	ABO10	2
Amazon Rainforest	ABO16	3
Amazon Rainforest	ABO22	4
Amazon Rainforest	ABO28	5
Grassland	ABO6	1
Grassland	ABO12	2
Grassland	ABO18	3
Hawana	ABO5	1
Hawana	ABO11	2
Hawana	ABO29	3
Panacea	ABO24	1
Temperate Forest	ABO3	1
Temperate Forest	ABO9	2
Temperate Forest	ABO15	3
Temperate Forest	ABO21	4
Temperate Forest	ABO27	5
Temperate Forest	ABO1	6
Temperate Forest	ABO7	7
Temperate Forest	ABO13	8
Torrential Rain	ABO19	1
Torrential Rain	ABO25	2
Torrential Rain	ABO2	3
Tropical	ABO8	1
Tropical	ABO14	2
Tropical	ABO20	3
Tropical	ABO26	4

Thank You all

[abhijitnalekar · Accepted solution]

Hi @prahlad_infy ,

Create new field in the script as

autonumber(rowno(),Feature)as Rowno,