Looking for a specific words in a datatable

Help Studio
, ,
1

I read a excel sheet with hundred rows and 20 columns without headers. (so the column name was column1, column2 …)
The data of this datatable contains a unique word called “Test”. How can i find out this “Test” was from which column ?

2

image
image1409×719 15 KB

as a example, it was like this, how can i figure out the column of the “test”

3

@Wei_Ji_Kwok

4

@Wei_Ji_Kwok use this sequence
uipathF.xaml (13.1 KB)

example input

image
image914×240 7.77 KB

result
image

5

thks a lot, it was wat i need

1 Like
6

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