my job is to scrap data from a webpage (it’s only 1 column), then check if a certain value (known earlier) exists in that table/column. Then, if this value exists, I have to perform one action and if it doesn’t - another one.
Do you know how to do it? I tried with ExtractDataTable (output of data scrapping) then for each row, in Body - If Rows(“Column1”).ToString = DesiredValue. The problem is that it looks like it analyzes not if a value is in a table, but if rows are equal. It affects further actions, because they are carried out as many times as many rows are in a column.
Your help will be very appreciated!