I’m using Make.com’s MySQL module to fetch rows, and each row comes through as its own “bundle” with fields like generation, yearstart, yearstop, roofload, and hersteller. What I need is a single array where each element is a formatted string concatenating those values—for example:
[
“A3 (8L), 1996, 100, Audi”,
“A3 (8P, facelift 2005), 75 , Audi”,
…
]
How can I transform the individual bundles into one array of these concatenated strings?
Welcome to the Make community!
To do this, you can try using the Tools “Text aggregator” module —
Aggregates multiple strings into one text.
For more information, see https://www.make.com/en/integrations/util, and https://www.make.com/en/help/app/util in the help centre.
Alternatively, you can use the Tools “Compose a string” module —
Composes a string for easier mapping of scenarios.
If you do this you’ll need another aggregator.
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.
