Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
check sample example
Hi,
Am not sure . you can try field index function
just load rowno() and make life easier?
sample :
A) Field Index :
Syntax: fieldindex( fieldname, value )
e.g. the field name must be enclosed by single quotes.
This is like vLookup.
Example:
From this above table Field Index ,
Output:
check sample example
Thanks !!
welcome
One more way you can do this is as below with a straight table:
Expression for Row# is : =Aggr(RowNo(),id)