Pivot table without merged columns

Hi,
I have a data set:

When I do pivot in Knime the pivot columns are merged and the result is hard to read:

I would like to create a pivot table that does not merge my pivot columns:


How can I do it?:slight_smile:

Hi there @MarcinC,

welcome to KNIME Community!

Pivoting node can’t do this and in general you can’t have Excel format in KNIME so to say. What is you goal? Export data to Excel file or have better readability in KNIME?

Br,
Ivan

thank you for the answer!

My goal is to have better readability. I can accept different form of the result.

Hi @MarcinC,

I see. Maybe Table View would be better then. Together with renaming your columns?

Br,
Ivan

thank you! I wil try it:)

1 Like

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