What are you trying to achieve?
Hello! I’m trying to build a scenario where I get multiple items (1st Search Rows, it’s just an example as the actual scenario is pretty long) and I want to check if they’re in Sheets already (2nd Search Rows + aggregator + filter)
My concern is, though it works, it searches and aggregates as many times as the Iterator says, but I can’t aggregate the array as I use the values in the filter and they wouldn’t be accessible anymore.
Any suggestions on how to work around this? And how to add all the rows in one operation?
Hey there,
could you please clarify a little bit what you are trying to process with this?
What is the first search module searching for? Then what is the iterator iterating over? Then I assume the second search module checks if the item from the iterator exists somewhere else? Then what is it aggregating and what are you trying to filter before adding the row?
Hey @Stoyan_Vatov thank you for your reply.
Instead of the first search rows module there’s actually the results from an Apify scraper, the Search Rows is just a substitute so as not to run the entire thing every time.
The iterator iterates the “name" column of the Search Rows, and in the real scenario it iterates the names scraped with Apify.
Then there’s the actual Search Rows (2nd one), which I aggregate into a text to then verify if the scraped names (the result of the Iterator) are already contained in the Google Sheets. If they aren’t, a new row is created with all the elements scraped with Apify. This is done with the filter (second image)
The scenario works, my only issue is that the 2nd Search Rows and the aggregator run as many times as the Iterator, which I don’t actually need.
Thank you again!
