Hi there, I have a google sheets table “Date, Description, Amount” there are several and dinamically filled rows.
I can put them into an array (image attached)
What I need is to format and store all data in one single variable in the following format:
Date1 - Description1 - Amount1 | Date2 - Description2 - Amount2 | Date3 …n
Where the numer is the collection number, more specifically taking the data from the image will be something like this :
2024 - Table - 496 | 2024-10-27 - Chair - 67 | and so on…
Is this possible?
Delete the Array Aggregator and use a Text Aggregator.
Aggregators
Every result (item/record) from 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.
There are other types of aggregator modules, click the below links to find out more:
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.
You can use a Text Aggregator like this:
The output should present like how you want.
2 Likes
Welcome to the Make community!
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
Help Centre Basics
Articles & Videos
Thank you very much! That was exactly what I was looking for!
Also thanks for the links, definetly will check them out.
Cheers.
Thank you very much! Exactly what I need!!
Cheers
