Concatenating values from sublist

[Andrew_Hannell]

Hello

I would like to concatenate the values from sublists (of varying length) into a single value.
I have tried various list nodes (slice,chop,flatten)- the below is as close as I can get.

In the below example, I would like to concatenate values from sublist[0] to be “FIRE PIPEWORK, FRP”
Likewise, sublist[1] to be “HANG DOORS, FRP, SHEET WALLS, STRIP”

thank you in advance

[Andrew_Hannell]

To answer my own question:

Since the data source is an SQL database, I can create a query for the grouping/concatenation- refer below.

But if anyone has an idea to achieve the same in Dynamo, I would be interested to know how to do this.

Andrew

[Monkey_Puppet]

[Andrew_Hannell]

thank you

easy when you know how…

Andrew

[Monkey_Puppet]

Just like everything in life.

[Jason_Parker]

Story so far of my Dynamo life. Luckily it keeps it exciting. My approach to Dynamo is, it’s sort of a cure for cancer. I started with it at the “seek and destroy” level of data manipulation, but now I’m getting closer toward laser surgery with my scripts. About every few days I run across a new node I’ve never used and get blown away at what I can do with it!

It’s a struggle, but one with a good payoff at the end toward automation!

[hmidahbb]

please package name

[solamour]

please package name

Are you looking for String.Join @hmidahbb? If so, this is out-of-the-box functionality

The Code Block is also out-of-the-box!

[hmidahbb]

i mean query node

[solamour]

Ah, then I’m unsure of what package that one’s from… @Andrew_Hannell do you happen to remember ?

[Kulkul]

@solamour

then I’m unsure of what package that one’s

@hmidahbb it’s from slingshot package.

[hmidahbb]

@Kulkul

slingshot

thanks a lot