Create Table

KNIME Analytics Platform
#1

Hello,

I was wondering how to convert columns into a table as followed:

Columns (input):

Letter   Value   DoubleLetter

A           2          FG

B           4          HZ

A           5          JK

C           1          KL

B           5           KL

 

Table (output):

           A    B   C

FG      2    -     -

HZ       -    4    -

JK       5    -     -

KL       -    5     1

 

Thank you for your help!

#2

Hi,

you can use the pivoting node with the following configuration:

- Groups: Select DoubleLetter

- Pivots: Select Letter

- Manual Aggregation: Select Value with First as Aggregation Method

Cheers,

Kathrin