How to check if datatable output column field contains specific text like yes or no

[Rahul_Unnikrishnan]

Hello @vnsatyasunil

You can refer to the below post. Loop through each row and pass the row number in the expression(can use a counter variable). Then it will give the column index

Get column index and row index for specific values

Hey everybody, I have a huge excel file(s) with different sheets. Since the next sheets and next files can look slightly different from each other there is a common header in each file to find the correct column. So I only get the information in which row the common header is (e.g. row 50 in the example below). [image] So the task is to look for the Value NPP and get the column index. Once I have the column index I can get the row index for a string that starts with “D.” (see below). But I do…