Pivot Table and Concatenate Columns

KNIME Analytics Platform
1

Does anyone know a KNIME-solution for Pivot Table and Concatenate Columns:

Further information:

https://stackoverflow.com/questions/213702/sql-server-2005-pivot-on-unknown-number-of-columns

https://stackoverflow.com/questions/159456/pivot-table-and-concatenate-columns?noredirect=1&lq=1

I try to avoid to solve this problem with the proposed solutions on stackoverflow, but it is exactly what I need.

I just want to wether KNIME is able to achieve this.

2

Hi,

sure we have a pivoting node, which can do exactly what is requested in the first link. and it also cover the example in the second link.

Cheers, Iris