Data Files in Katalon

How to get the particular Row index for the given value
for example when the value “John” is given it should print its first row index “1”

If “Henry” it should display “3”

hi,

this is one way to do it, use loop index

InternalData data = findTestData(‘SpamData/someSpamTestData’)

def ro = data.getRowNumbers()
println "count of rows "+ro

search = “book”

for (int i = 1; i< ro; i++){
if (data.getValue(1, i).equals(search)){
println ("row index: "+i)
}
}
image

row index: 3

1 Like

Great Working Cool, Thank You.

Timo_Kuisma1,
how is it possible to get row number of specific column?
My Excel data hast multiple column with different number of rows.
Regards,
Dmiti

Hi,

in a loop as I have added my previously command