How do I compare a runtime parameter to a field in the Excel sheet

Get Help & Discuss Process Studio
1

Hi, I am new in the AE universe, so I need a robot that takes three runtime parameters, name, date and value, and checks if these three values ​​match a certain line in my Excel, if they do, it returns true, how can I do this?

2

Hi! Vinicius

You can add a ‘Get Variables’ step in your workflow usually as the first step. In the Get Variables step get the variables/parameters to put them s fields in the workflow.

You can then lookup these fields in the Excel file using the ‘Stream Lookup’ step. You can read the Excel file in an Excel Input step.
The following image shows a basic workflow.

image
image978×344 11.9 KB

1 Like
3

Hi Seema!

And how can I compare these two strings in a way, just like the SQL LIKE operator? For example, if the name in Excel is Cristiano Ronaldo Junior and the user sets it as Cristiano Junior only, the Excel line specific to that name must also be returned, in the same way as you did above

4

Hi Kock03.
Data from excel is read as is. During the transformation, you could use Fuzzy Match.
Hope this helps

1 Like