Get Datatable Row value based on a search string

Help
1

Hi All,

I’m new to Ui Path and working on datatable.
I have a query to get the Column name based on a string value.
image

From the above, I want to get the complete row value in which contains(“How”).
Can have multiple rows which contains (“How”), I want the row values as concatenated string and I dont know the column index/name(can vary).

Regards,
Megh

2

Hello Megh and welcome to the community!

Is “How” only going to be present in the Column3 or it can be found anywhere in the DataTable?

3

It can be found anywhere in the datatable.

4

FindHow.xaml (9.6 KB)

So you are first going to loop through the Rows, then the Columns, to search every item in the DataTable.
After that, you are going to check for the “How” word, if that word is found somewhere, you are going to use String.join(“,”,Row.itemArray) to get the whole Row value.

Hope it is clear

5

Did this help you @Megh

6

Yes, Thank you

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.