Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @prahlad_infy ,
Create new field in the script as
autonumber(rowno(),Feature)as Rowno,
Hi @prahlad_infy ,
Create new field in the script as
autonumber(rowno(),Feature)as Rowno,