Lookup with wildcards

[mateo.drouillard]

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 !

[Nithinkrishna]

Hey @mateo.drouillard

You want to search datatable by part of a string but not the entire value is that correct?

Thanks
#nK

[mateo.drouillard]

Only part of string

Thank @Nithinkrishna

[Nithinkrishna]

Hey @mateo.drouillard

Try the below please,

dtData.AsEnumerable.Any(Function(row) row("columnName").ToString.Contains("part of your string"))

The above will give you either true or false.

Hope that helps.

Thanks
#nK

[Nithinkrishna]

Hey @mateo.drouillard

If you want to filter itself then,

dtData.AsEnumerable.Where(Function(row) row("columnName").ToString.Contains("part of your string")).First()

The above gives you a matched data row.

Hope that helps.

Thanks
#nK

[mateo.drouillard]

Thank for your reply, but where i put this ?

[Nithinkrishna]

At the place of Lookup in an Assign statement.