Hello community, I have the following problem: I have a lookup row that needs to recognize consecutive IDs: ID1, ID2, etc.
When running the scenario, it only executes row 2 (the first one contains the headers).
So it doesn’t advance. (ID1…ID2…etc.)
I also want to mention that, in the lookup row, I’m filtering several headers in my project. After the first module, I go to a router, from where it branches to an interactor (carousel images). Another path is a single image, and the last is a video (this is simplified for the question; it contains more paths).
The goal is to recognize the numerical order before deciding which path to use.
I’ve tried filtering by numeric text, execution ID, by group, using the AND/OR rule. And it doesn’t work.
My scenario is divided into several actions that come from an Excel file that doesn’t have formulas or anything, just text.
I hope an expert can help me out!
Thanks!
1 Like
Heyy @Gabriela_Capote
You wont get any row data using search row module if you map “execution id” in filter value, as execution id is unique and it’s a value of make scenario execution.
If you ID column has values like ID1, ID2, ID3, and so on you can use text filter with contains “ID”. So it will list all record with rows records which has “ID” in selected column.
If you can share your sheets data and share your brief not on what you are looking to search in detail. i can help further!
Best,
@Prem_Patel
1 Like
First of all, thank you very much for your time!
I’ve attached a PDF with the Excel structure.
Let me explain the logic by color.
The routers work like this:
The orange item is a single image router.
The pink item is a carousel image.
The ID is clearly green.
The light blue item is square content, and the purple item is vertical content.
The red items are the updates after the scenario is executed.
The scenario only runs row 2, always.
Plantilla X.pdf (56.8 KB)
helpme!