Get row and column index of cell with specific value

Help
,
1

I have a datatable and I need to find the position of one variable that appears in this data set. To be specific I need the column in which this variable exist. Values are unique, so there are no duplicates. Any suggestions?

2

Hi @trolleylolley,

Refer the below thread

Refer the below post for reference

1 Like
3

Thank you! I’ve did that using For Each loop with Lookup Data Table activity inside it.

In my case: List variable contains SAP symbol, and I look for correlated system name in data table.

You only need to change the names and indexes of columns where to look for data.

Feel free to use this workflow in your projects :slight_smile:

correlated_values.xaml (8.8 KB)

1 Like
4

Hi @trolleylolley,

Can you close the topic if you have received your solution

5

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