How to get the results of a DataBase and turn it into usable variables?

[kalllilll]

I have a database that is structured like this:

I want to turn this database into variables of the Company name (key) and Company Total Spent (Gasto) because I need to send it through a http request and make my text. But instead of showing all the company names and company total spent so i can click and use the variable, it shows only the last one.

I know I can use map to get each one but it’s really bad to have to create each map function for each company and each budget to create the message, that’s why I want to create a variable for this values so I can just click in it.

I tried using aggregator, iterator, set multiple variables, set variables, everything you can imagine.

[samliew]

Welcome to the Make community!

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, 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.