Data Transformation

Hello KNIME community,

I am currently facing an issue with data transformation, and I would appreciate your guidance. The input data is structured as follows:

Screenshot 2024-02-21 110003

I would like to transform this data into the following format:

Screenshot 2024-02-21 110149

Your assistance in achieving this transformation using KNIME would be highly appreciated.

Hello @lara77,

You can achieve the desired data transformation using the “Table Transpose” node in KNIME.

Additionally, consider using the “Row to Column” node to further structure the data as needed.

For your reference, please check the attached images.

Screenshot 2024-02-21 110726

Result:

Screenshot 2024-02-21 110914

3 Likes

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