Datatable LookUp

Hello everybody,

I Want use ‘Lookup Datatable’ activite but in LookUp Value i want use wildcards for dosn’t search only the exact string.

It’s possible ?

Thank !

Hello @mateo.drouillard

I guess we can’t use use wild cards in the Look Up Data Table. We can search for only exact string. Can you please let us know what is the string you want to match. So that we can assist with few other ways to deal this


We can’t use the wildcards in LookUp value, As this will considered the wild card as a value…

But we can do like this…

Use Excel as a database and we can use wildcards to find the data…


Syntax to find the value in SQL…

SELECT * FROM Customers
WHERE City LIKE '%es%';


SQL Wildcard Characters.