Transpose row to column and column to row

[ipazin]

Hello @fredrikt,

you can use join() and substr() functions from String Manipulation node to transform 2021 Jan to Jan-21.

Br,
Ivan

[Kenyx]

@ipazin

no group columns, Label as pivoting column and Value as aggregation column with aggregation method List.

Hi @ipazin , this is really helpful.
But I met some problem during the final execution, execution failed and inform

Execute failed: Java heap space: failed reallocation of scalar replaced objects

Is there any method to fix this?

[mlauber71]

@Kenyx maybe you could explain further what kind of operation you wer doing and what your system is like. If you have costly operations you might want to take a look at these discussions:

Knime processing power blocking at every single step after finished flow

@Gonzo welcome to the KNIME forum. You could try and give KNIME 10-12 GB but not more and not run any other jobs. Is this a Windows machine and does it have an SSD hard drive. Then you could explore this collection about KNIME and performance You might try: Garbage collection columnar table backend splitting the workflow into several parts and calling them separately while resetting them at every start (maybe a last resort)

Knime processing power blocking at every single step after finished flow

@Gonzo I have no experience with Windows 11 as of now. These things come to my mind when you mention a large ungroup (or any other complex operation for that matter): the Cache node. Sometimes I have experienced that before complex operations after a long data manipulation stream KNIME ‘likes’ a Cache node in order to bring all the changes back to one place then you could see if forcing the node to write something to disk can help, also if you try different underlying encodings in the knime.i…

[Kenyx]

Hi @mlauber71
I am pivoting a large mount of unpivoted datasets, my config of memory is set up to 8G, when I executing the whole program is flashing and the Windows taskbar can see multiple knime program open and close.

[mlauber71]

@Kenyx maybe you open a new thread with some more details about your system and your data. Transpose can be a costly operation. 8 GB might not be that much.

[aworker]

Hi @Kenyx

@Kenyx

I am pivoting a large mount of unpivoted datasets, my config of memory is set up to 8G, when I executing the whole program is flashing and the Windows taskbar can see multiple knime program open and close.

Did you solve this problem ? If not, I would be happy to help with it if you open it in a new thread as suggested by @mlauber71

Best wishes,

Ael

[Kenyx]

Hi @aworker ,

Thank you.
I already solved this problem, I made mistake on pivots and aggregation method.

BR
Ken