Dynamic rows to columns

KNIME Analytics Platform
1

Hello there,

I am new to Knime and would appreciate help in figuring out my issue of creating dynamic columns from one single column

Data I have is as follows:

Patient_Id, ship_date
A, 2023/12/10
A, 2023/12/28
B, 2023/8/9
B,2023/8/17
B,2023/9/5

The output I am looking to get is as follows
patient_id, ship_date_1, ship_date_2, ship_date3
A, 2023/12/10, 2023/12/28, NULL
B, 2023/8/9, 2023/8/17, 2023/9/5

Thank you

2

Hi @socalds

That would be a job for the groupBy, Cell Splitter and Column Rename node’s. A similar case came up recently.

2 Likes