Baileo
September 7, 2023, 11:15am
1
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
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
Baileo
September 8, 2023, 11:09am
3
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.
Baileo
September 8, 2023, 11:25am
5
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
Musoka
September 18, 2023, 4:08pm
7
Hi @Baileo did you manage to get it to work?
Facing a similar trouble as well.
1 Like
Nick_B
November 6, 2023, 4:53am
8
I’m having the same issue. The solution above doesnt work.
Nick_B
November 6, 2023, 4:53am
10
Hi Baileo, did you get this working?
Runcorn
November 6, 2023, 5:46am
11
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
Nick_B
November 6, 2023, 9:28pm
12
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)
Logan_R
November 19, 2023, 12:50am
13
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!
3 Likes
Nick_B
November 19, 2023, 10:53pm
14
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.
2 Likes