order after pivot

[Heinz]

Dear all,

I have a result pivot table from pivot that you can find in attached workflow.

test3 to knime.knwf (12.9 KB)

Everything fine, except that I need the same order after pivot than in output after node column expressions (only in horizontal, not in vertical as shown below):

Object Description H001
Sub Object Description H001
Serial No H001
Installationdate H001
Latest Installationdate H001
Object Type H001
Object Level H001
Object ID H001
Object Description H002
Sub Object Description H002
Serial No H002
Installationdate H002
Latest Installationdate H002
Object Type H002
Object Level H002
Object ID H002
…

Object Description H020
Sub Object Description H020
Serial No H020
Installationdate H020
Latest Installationdate H020
Object Type H020
Object Level H020
Object ID H020

I tried with RowId node and sorting but I did not get the result I need.

Do you have any Idea?

BR,

Heinz

[ActionAndi]

Hi Heinz,
I’ve downloaded you workflow but I do not get an idea what the purpose of the pivoting is. Just reshaping?

If you just want to have these colums as rows, try “Table transposer” (I use Knime 5.4)

[Heinz]

Hi Action Andi,

pivot table from node pivot shows the following columns:

Installationdate H001
Installationdate H002
…
Installationdate H020
LatestInstallationDate H001
LatestInstallationDate H002
…
LatestInstallationDate H020
ObjectDescription H001
ObjectDescription H002
…
ObjectDescription H020

I need the order:
Object Description H001
Sub Object Description H001
Serial No H001
Installationdate H001
Latest Installationdate H001
Object Type H001
Object Level H001
Object ID H001
Object Description H002
Sub Object Description H002
Serial No H002
Installationdate H002
Latest Installationdate H002
Object Type H002
Object Level H002
Object ID H002
…

Object Description H020
Sub Object Description H020
Serial No H020
Installationdate H020
Latest Installationdate H020
Object Type H020
Object Level H020
Object ID H020

[ActionAndi]

Ah you just want to sort the columns names according to H0xx

Heres the link to my workflow at the KNIME hub:
https://hub.knime.com/s/xa-OblUEU54srjiQ

[Heinz]

Thank you very much for your help!