Hi everyone!
I’m working to get the contents of a Google Doc (which admittedly has some strange formatting) and then subsequently extract ONLY the values from the document that follow the value “Yes”. See the screenshots for an example of how the Google Docs is formatted.
My text parser module is working generally as intended (it’s only extracting the values with “Yes”) but I’m confused why it’s running 8 operations when it should only be running once. Each of these operations are duplicates and display the exact same data. Is there something wrong with my Regex? Or is there something wrong with my Google Docs configuration that it’s outputting 8 operations - but if this is the case why do the other icons only show 1 operations being used?
Any explanations would be much appreciated as well as possible solutions! Thanks! Happy to provide more details.
1 Like
Welcome to the Make community!
You need an aggregator to combine bundles.
Combining Bundles Using Aggregators
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
You can find out more about the other types of aggregator modules here:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hi @Noah_Latsch
That is because your input source module must be having 8 bundles in output. To run the next module only once, you need to utilize array aggregator before match pattern module.
Hope this helps.
Regards,
Msquare Automation - Platinum Partner of Make
@Msquare_Automation
2 Likes
Hey Sam - appreciate you getting back to me so quickly.
What the original photos didn’t show is that I am already using an Iterator + Array Aggregator + Set Variables prior to my text parser. In fact, I’m using two text parsers because i need to perform two distinct operations on the text I’m getting from the Google Doc. (see photos)
As you can see in the photos, simply changing the order of the text parsing modules has a dramatic effect on the number of operations they consume - though they do not directly reference each other. Can you help me understand why this might be?
If I ONLY run the Find “Yes” module, it consumes 1 operation but when i run it after the Extract Every Other Line module, suddenly it consumes 8. With each of those being duplicates operations.
Thanks again for your help - really appreciate it!
The first Match Pattern module is returning 25 results as separate bundles, so you will need an Array Aggregator.
Read the bolded part:
Every result (item/record) from trigger/iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
For more information, see Make Basics
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
