Combine Operation Values into single string

Baileo · September 7, 2023, 11:15am

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

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

Msquare_Automation · September 7, 2023, 12:37pm

Please use text aggregator module with , separated

Make sure you have choose the source module properly.

Baileo · September 8, 2023, 11:09am

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

Msquare_Automation · September 8, 2023, 11:24am

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

Baileo · September 8, 2023, 11:25am

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

Msquare_Automation · September 8, 2023, 11:35am

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

Musoka · September 18, 2023, 4:08pm

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