I have no problems filterin a data table using the Select method when I use a literal as the value to select for the column, but for some reason I am unable to get it work with a variable. It appears to be returning no values. I probably have the incorrect syntax:
Assign CountryRow = in_CountriesDT.Select(“Country = ‘in_CountryName’”)
CountryRow is an array of data rows. in_CountriesDT is the datatable passed into the workflow. in_CountryName is a string argument containing the country name passed into the invoked workflow. “Country” is the column name in the data table. There is one row matching the country name, so it should return a single row. It works fine when in_CountryName is replaced with a literal.