String manipulation for each column

KNIME Analytics Platform
1

Hello,

I have a table like this :

Initial table
C1 C2 C3 C4
val1 val2 val3 val4
... ... ... ...

And I want a table like this :

Goal
C1 C2 C3 C4
C1:val1 C2:val2 C3:val3 c4:val4
C1:... C2:... C3:... C4:...

 

I try to do that with a node "String manipulation" but it doesn't work as I want. The only thing that I can do is to made a join() manually for each column... I guess there is a better solution.

Can someone help me ?

A great thank you by advance,

Tixinoo.

2

Hi Tixinoo,

You can do this if you base your workflow on the Extract Column Header node, so the attached example.

Cheers,

Roland