Combine Operation Values into single string

Hi
I have this scenario which has multiple outputs from mysql:
image

Rather than 1 operation with multiple bundles, its multiple operations. I need to concatenate the results into a single comma separate string.

So each of these Operation results has a field called “id” and I need to compose a single string of all the IDs separated by a comma i.e. 1,5,65,7

Any help appreciated

1 Like

Hi @Baileo

Please use text aggregator module with , separated

Make sure you have choose the source module properly.

MSquare Support
Visit us here
Youtube Channel

1 Like

Hi
I’ve set that up but it still outputs 8 separate operations rather than a single concatenated string:

Hi @Baileo

Please check the selected source module. This happens due to the selection of source module.

Hi
I am selecting the prior module. Is that not correct?

Hi @Baileo

If you are mapping the terms inside MySQL from webhook then please use webhook as the source.

If the issue persists, please connect to us
MSquare Support
Visit us here
Youtube Channel

Hi @Baileo did you manage to get it to work? :slight_smile:
Facing a similar trouble as well.

1 Like

I’m having the same issue. The solution above doesnt work.

Hi Baileo, did you get this working?

Hi @Nick_B,

Can you share what your scenario looks like, the most important thing is to use Source Module in the Text Aggregrator, for eg. if it is a Mysql search module that outputs multiple bundles, then the source needs to be the MySQL module.

1 Like

Sadly, I think it’s a Make limitation.
We CANNOT do the following:

Multiple Operations → One Operation or Object

We CAN do the following:

Multiple Cycles/Bundles → One Object (Using Aggregator)

AND

One Cycle/Object → Multiple Cycles/Object (Using Iterator)

Hey, @Nick_B I think I figured it out! So, @Msquare_Automation is correct about how to use it, but didn’t distinguish what module is actually the ‘Source Module.’ I created two images that hopefully will help with understanding! :beers:

4 Likes

Ahh yes. Thanks for that.

So the key factor is WHICH source module is selected for the Agg.

If you want only ONE operation as output, you must select the source module that only has ONE operation as output.

3 Likes