How to check for every cell if it contains a particular string in a datatable

Hi,
Can someone please tell me how I can search for a particular string in a cell, and find its corresponding column name
The sample table would look like below:

image

I need to look for ‘-Yes’ in the cell, and then give me its corresponding column name

Thanks in Advance!

@PavithraSundaram
find some starter help here
GetAllRowColIdx_By1Value.xaml (9.5 KB)

input:
grafik
output:
grafik

it is looking for a searchterm and is returning, rowindex, columnindex and columnname for each found match

Feel free to adopt it to your scenario

2 Likes

In excel? You can just use a filter on Col2
Datatable in UIpath you should be able to use function to filter the dt where column contains the string. Her is one that may work:

Thank u so much! I shall try this…