Google Sheets not Filtering from Array Aggregator

[Forza_Accessories]

I am trying to filter my rows to Google Sheets but the Rows are still appearing that i am wanting to filter out. “Anything that has the word ITEM:” in it. Please see images

[Greatness_Workflows]

Hey @Forza_Accessories , welcome to make community.
Where is the data coming from ?

[Forza_Accessories]

Hello, Thank you for your reply. Please see pictures. Coming from Unleashed

[damato]

Hi @Forza_Accessories

From what I understand of your scenario, you are repeating N calls to Unleashed module. This module then returns an array which you are iterating over (Items[]?). Then you Aggregate the results to match the Bulk Insert rows.

Try setting the Source Module of the Aggregator to be the Iterator and add the filter between these two modules. Filter with a Text operator where {{3.ProductCode}} does not contain (ci) ITEM.

@damato

[Forza_Accessories]

Hi @damato,

Fantastic that worked! Must put the filter between the Iterator and the Aggregator instead of afterwards.

Thank you