Data Files in Katalon

Web Testing
1

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"

profession datafile
profession datafile1006×426 5.04 KB

2

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
image533×138 2.28 KB

row index: 3

1 Like
3

Great Working Cool, Thank You.

4

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

5

Hi,

in a loop as I have added my previously command