Lookup Datatable using Wildcards Issue

Hello,

I am having an issue where the Lookup Datatable activity doesn’t work with wildcards. I’ve set up my table configurations as pictured:
image

There is only one column in GetData_US_CAN, and I’ve checked to make sure it is populated (it is). When I try looking up the exact value it works, but not with the wildcard. Is this a studio limitation? Or am I doing something wrong?

Thanks,
Nicole

2 Likes

Hi
lookupvalue property is to be passed either with a variable or a exact string value
and we wont be able to mention wildcards out there buddy
is there any reason behind that
Cheers @Nicole_S

4 Likes

Hi @Palaniyappan

Ok, thanks!
Currently I’m just iterating through each row and using IsMatch activity. I just wanted to make my workflow more efficient :slight_smile:

Thank you!

Nicole

2 Likes

Fantastic
Cheers @Nicole_S

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.