Partial match by searching data table

Help StudioX
, , ,
2

HI @ri-na

I think we can’t pass a string with wildcards in Lookup datatable it should be either complete word directly or by assigning it to any variable.

Can you try this way
Use for each row in datatable and loop through all the column

  • If Row(“Column2”).tostring.contains(“AAA”)
    • Look up value and pass the whole string as value Row(“Column2”).tostring and get youe index and cell value

Regards
Gokul