Pivot Node ?

KNIME Analytics Platform
1

Hello,
My file is currently presented like this (top of the file). I would like the columns to become rows while keeping the data by Name and by Date (second part of the file). I have tried using PIVOT but it doesn’t work.
PIVOT1.xlsx (9.3 KB)
Thanks for your help
Br

2

Hello @Brain
You would need a two steps transformation:

  1. Unpivot Value Columns with ‘Unpivoting’ node
  2. Pivot $Cheval$ category column with the help of ‘Pivoting’ node

BR

1 Like
3

I have this result :
KNIME_project6.knwf (75.8 KB)
Br

4

Hello,
Based in your example data, this workflow achieves your expected result.

20240126_KNIME_project6_v0.knwf (33.6 KB)

From my perspective, shape data in this way, it has a single Cheval item visualization purpose.

In the case of more Cheval items, and aiming a single cheval visualization; you may think about creating a visualization component, supported with visual selectors and Tile views.

BR

2 Likes
5

P.S. - for a better performance (sorter function), please replace the first String Manipulation node’s code with the following:

join(
	string($Année$)
	, "-"
	,padLeft(string($Mois$), 2, "0")
	, "-"
	,padLeft(string($Jour$), 2, "0")
)

20240126_KNIME_project6_v1.knwf (74.9 KB)

2 Likes
6

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