Knime pivoting and formatting

[nizamuddin]

Hi,
Am new to KNIME, Can some one please suggest on how I can achieve this in KNIME.

Am able to group by and got the below results, but what I am trying to achieve is to group the year under IntCard

This is what I got when used group by on the data.

[gonhaddock]

Hi @nizamuddin and welcome to the forum.

An alternative would be to extract the YEAR from IntCard and ‘Group by’ using this column.

substr( string($IntCard$), 0, 4 )

Regards

[ipazin]

Hello @nizamuddin,

if you are looking to add sum row in between then take a look at this topic:

Add rows in between

Hi all. I am looking for a function to add rows in between my existing file. The table consists of several columns and rows. In column A and column B there are indicators in order to group the data. The rows should then be added in between the different groups and state the name of this group. Is there any function that could help me?

Otherwise can you try explaining it a bit more. Hopefully with some input data and desired output. Dummy data works just fine (or even better in your case due to large numbers).

Welcome to KNIME Community!

Br,
Ivan

[nizamuddin]

Hi Gonhaddock,

Thanks for the reply, but I am trying to achieve the pivoting format here, where the data is grouped under other grouped column. Is this possible with KNIME. Please advice.