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.
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
