In here I only want to aggregate the first 9 bundle to the text.
I have defined the JSON structure (I think it’s correct)
but then not sure what should be the next step…
Hello @Keith_Cheung,
If you only want to aggregate the first 9 bundles of the #15 Iterator, then you might try using a filter.
Click the Wrench between Iterator and Google Sheets, then filter would be Bundle Order Position <= 9.
3 Likes
it doesn’t work with bundle order because each operation could return different number of bundles and setting the bundle order =< 9 only filter the bundle within the operation but not the total bundle across different operations.
What if you try setting “Maximum number of returned rows” in Google Sheets module to 9?
3 Likes
it’s a iterator of 3 different search term in the google sheet, and I need to control the total results which is less than 9…
@samliew has suggested to use Parse JSON and Slice but i’m not sure how to operate…
Heya @Keith_Cheung 
I just want to quickly step in to say awesome work figuring this one out with the guidance of @Donald_Mitchell 
Also, thanks a lot for circling back to the community and letting us know that the increment function got this up and running for you. This is super valuable and can be incredibly helpful to many others who are looking for similar info in the future 
1 Like