Data Files in Katalon

[divya.hari]

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"

[Timo_Kuisma1]

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)
}
}

row index: 3

[divya.hari]

Great Working Cool, Thank You.

[kax99856]

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

[Timo_Kuisma1]

Hi,

in a loop as I have added my previously command