converting group by lst element to string

KNIME Analytics Platform
1

Dear all,

I am using group by node to collect data from different rows; all source data from type string

I have choosen list option in group by node. In the corresponding element I see correct values. (=ok)
If it comes to multiple hits, Knime uses [ ] around the value and , for separating the values.

I have to join the elements from group by to existing table using value lookup (=ok)

The type of this element from group by is list showing [...] in its header.

3 questions:
How can I convert it into string? (I have to write this field into an access db)
How can I replace the [ ] (by using replace?)
Can I cange the , as value separator to e.g. ; (, is already used in the value by user; so I have it multiple times, for separating by Knime and by the user using it in the normal value)

Thx for help!

BR,

Heinz

2

Hi @Heinz,

In the groupby node, if you use the List or Set options, KNIME will create an array containing the values which is why you are seeing it as [item1, item2, item3].

If you actually want this to be a grouping of items represented as a string, delimited by ;
e.g.
item1; item2; item3

you could use one of the Concatenate options (“Concatenate” or “Unique Concatenate”) instead of List. You can then also specify the “Value delimiter” at the bottom of the GroupBy config.

2 Likes
3

Thank you very much for your help!

4

You’re welcome @Heinz.

image
image995Ă—41 7.53 KB