I have a Data table consisting of 20+ columns and 5000+ rows.
I like to avoid using a for each loop as it will be time consuming so is there an efficient way of searching the WHOLE data table to see if it contains the variable “Unique” and get the data of that row and first column where its found.
We could utilise the lookup data table activity to avoid for each row loop.
But lookup data table activity only search for the given column name or index to search the given value.
For work around we can get the column number count from the data table or excel.
Loop the column index this will loop only max 20 times and enter this column index in the lookup data table to improve the search in all the columns to get the cell reference.
It might be other work around. Please try to do the above approach and let us know. For reference please review the below link.