Table Creation Manipulation

Good evening guys, how are you ?

I need your help to carry out this table change, I tried using the unpivot and pivot nodes but I was unable to achieve the expected result, I would like to understand with you if it would be possible.

I colored the columns to make it easier to understand how to return.

KNIME_project3.knwf (5.7 KB)

Hi @Gabriel2020

This is one way to it table_creation_manipulation.knwf (33.7 KB)
afbeelding

gr. Hans

2 Likes

Hey guys, how are you?

Next I needed your help, as the current workflow only helped for one week and I have other weeks in the table.

I will forward the complete information so that you can help me.

KNIME_projectTe.knwf (8.1 KB)

Hi @Gabriel2020

Iā€™m not sure how the output should look like. But I created this wf table_creation_manipulation_v2.knwf (89.7 KB)

The output is one-table. But with a little slice and dice you can create it into any format you like.

gr. Hans

2 Likes

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