If statement using keywords in excel

Help
1

I have an automation running which takes codes from excel and uploads it in a system, at the moment the bot uses a filter data table to filter out keywords in the description column i.e “license” and carries on loading the codes which don’t have the keywords. Is it possible to add in the bot an IF activity for when the key words are caught to do something different because i.e codes with the word “license” in them are loaded in a different way?

2

You can, but you will likely not want to filter your datatable so you can process each kind of row. The if statement would say Row("ColumnName").ToString = "license" in a For Each Row loop.