How to make data in rows as columns?

[ClaudsQuito]

Hi Everyone,

I am new to KNIME and I am trying to figure out how to convert these data in rows [Action] as columns? I want to show them as columns with the total costs.

[iCFO]

This is typically done with the Transpose or Pivot Node. Transpose flips rows to columns, Pivot (and UnPivot) allows for conditionally transposing the data using aggregation methods.

[ClaudsQuito]

This is the data I have currently:

…and I want it to be like this:

[ClaudsQuito]

I tried transpose and pivot and they don’t work the way I want it to be

[ipazin]

Hello @ClaudsQuito,

you don’t need Transpose node. Pivoting will do it all. Grouping columns are Project Number, Project Name, Location Description and all other column that have same values across multiple rows. Pivoting column is Classification and Cost is your aggregation column where you can use First aggregation.

Welcome to KNIME Community!

Br,
Ivan

[ClaudsQuito]

Why it does not allow me to execute?

I’m done configuring it like your instruction, now there’s no option for me to execute it. Maybe I’m missing something.

[sanket_2012]

Hi @ClaudsQuito ,
Could you please share a snapshot of the pivoting node’s configuration window for all three tabs, namely the grouping window, pivoting window, and aggregation window or the workflow, if your data is not confidential?

Thanks,
Sanket

[ClaudsQuito]

here u go

[sanket_2012]

Hi @ClaudsQuito ,
Can you add column COST in the Manual aggregation window to make the aggregation selection FIRST, as @ipazin mentioned? Keep only the “Classification” column in the pivot tab. The rest looks good.

Thanks,
Sanket

[ClaudsQuito]

ohhh… it worked thank you for clarifying. I misunderstood @ipazin 's comment… thank you all!