• Documentation
  • Workato Blog
  • Product Blog
  • Return to Workato
  • Login
  • Automation Institute
  • Documentation
  • Community Forums
New Topic
Discussions Recipe Building Applications Questions
D

David James Consulting Pty Ltd

started a topic almost 2 years ago

Searching for a Pattern in a Lookup Table column

Hello,


   I want to search a particular column in a lookup table for a given pattern.


   For example, let's say one of the rows for that columns has: "12342","544332",5533442"


   I want to search "544332" and find a match in that row.


   I hope that makes sense?  How can I do this?  


Thank you,


David.  

Marlon Muela

said almost 2 years ago

Hi David,


You can either use an action to lookup an entry or use a lookup formula to find a corresponding value. See image below:

Please also visit our docs regarding lookup table here.

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2022   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato
Topic views count