Dynamic rows to columns

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

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

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.