CONCAT EXCEL in KNIME...HELP!!!

[Pippobaudo89]

Hi there

i write my second topic today… id like to know if there is a node which concatenate my data in the sample under here

1;
2;
3;
4;

in this way

1;
1;2;
1;2;3;
1;2;3;4;

thanks so much!!!

[dzhanhir]

Hi @Pippobaudo89,

Thanks for contacting us!

I could suggest to use a Chunk Loop Node.

Here is a bit about this Node:

The Group Loop Start Node and the Chunk Loop Start Node

And please don’t forget about Excel Reader Node before Chunk Loop Node.

Best regards,
Dzhanhir

[victor_palacios]

If the goal is simply to go from

1;
2;
3;
4;

to

1;2;3;4;

You can use the Groupby node (ignore the Groups tab) and go to the Manual Aggregation tab. Choose your column, choose Concatenate to aggregate, and then choose your delimiter (space, comma, semicolon, etc.).

[Daniel_Weikert]

@Pippobaudo89

you can use Moving aggregation node (cumulative + concatenate) for that

here is the result