concatenate every 5o string values then start over

[brwright]

I need to build a string that takes 184 individual id strings and puts 50 together at a time. Like this:

My data looks like this:

id(string not int)
125384414
116479103
123499444
125729381
130193080
125828161
129520443
133249730
103330089
131754729
99630957
128142169
118547804
100596417
116466745
103283744
121158722
124263122
97490575
117430138
108896130
121160361
98603308
117502082
107418632
134373942
125167026
129227317
108100472
131589308
98008102
98253804
103466640
99656521
121879898
97232478
124057154
121162216
127428724
121599352
107095014
113106815
128361211
120900420
120891990
118709590
99550307
107979900
117615338
103389964
117456809
129973314
98123499
98865677
129620345
126444394
96836140
116924094
117763065
126950480
103221228
107121577
125359725
128169728
98268403
103435522
132140313
132192450
103087172
106719791
97725855
97232486
90153160
103900669
120873535
84033912
114398378
118789597
131677962
94566257
121907783
118731242
111692649
117160942
116314856
122584388
112033465
108769080
125611953
110044575
107344095
100068994
108644445
127422054
117395312
130973394
104204464
97751311
104886793
109858044
117574417
111916359
104879498
127987377
103209274
110534253
110312351
132952521
122468317
127982762
100435896
126633879
116536081
119739921
109089947
126778539
121993607
110524121
111696243
125666681
131821127
131755663
100808089
131139790
123248344
96887918
117807162
105242439
109104603
130752784
98341744
107761567
118008318
123545711
116805592
126950027
109238569
98877901
124253073
133475442
121183597
116749950
103247591
131883728
108945303
129719669
107416558
106374554
118972640
109686524
127920351
126411218
116055289
97049452
90921770
102991997
122021664
126948067
123213425
121074294
102937911
104320052
125697043
128681124
96850836
99579166
131428976
132929069
121211796
98504156
133594261
96652215
127102979
115928723
117901748
104949105
118629331
131725633
121163444
100656092
99264477
123042373
125487048
116262050

The result will look like this (50 at a time):

125384414,116479103,123499444,125729381,130193080,125828161,129520443,133249730,103330089,131754729,99630957,128142169,118547804,100596417,116466745,103283744,121158722,124263122,97490575,117430138,108896130,121160361,98603308,117502082,107418632,134373942,125167026,129227317,108100472,131589308,98008102,98253804,103466640,99656521,121879898,97232478,124057154,121162216,127428724,121599352,107095014,113106815,128361211,120900420,120891990,118709590,99550307,107979900,11761533

Repeated until all rows are processed.

(should have 4 results)

Should I use a control parameter or a multirow or a recordid that can start over after 50 each time?

Cant sort it out!

Thanks in advance for your helps!  🎸

[flying008 · Accepted solution]

Hi, @brwright 

I'm assuming you want to split by groups of 50 rows.  the gif case show all 18 rows and cut each 5.

[binu_acs]

@brwright another way of dong this, similar to @flying008 method

[brwright]

Thank you both! I was able to achieve it both ways! Excellent, great Community!