How to get the specified rownumber of a field in straight table

[#1]

Hi All,

Please help me out in this scenario!

How to get the row number for specified filed from straight table .

for example

if name = James then  should return 2

id	Name	Address
56	steve	US
90	James	UK
81	Jack	IND

[Chanty4u]

Hi,

Am not sure  . you can try field index function

[adamdavi3s]

just load rowno() and make life easier?

[Chanty4u]

sample :

           A) Field Index :

                                      Syntax:    fieldindex( fieldname, value )

• Returns the position of the field value in the field fieldname (by loadorder). If value cannot be found among the field values of the field fieldname, 0 is returned. Fieldname must be given as a string value,

                                                      e.g. the field name must be enclosed by single quotes.

                                        This is like vLookup.

Example:

From this above table Field Index ,

1. FieldIndex('Customer','Jenny') 

Output:

[Chanty4u · Accepted solution]

check sample example

[#6]

Thanks !!

[Chanty4u]

welcome

[trdandamudi]

One more way you can do this is as below with a straight table:

Expression for Row# is : =Aggr(RowNo(),id)