Changing the format of the table with addition of dates

Hi All - would appreciate some help for the following:

I currently have the data like this:

image

And I would like to transform it into this:

image

Thing is, also I would like the process to automatically add new dates down the column when I upload a new CSV with new dates in the future. Is that possible with Knime? If so how? I would appreciate all the help possible because I have been trying to do it for 3 days now using grouping and pivoting but I am just stuck.

Thanks in advance!

Hi @Menoufi welcome to KNIME Forum

An Unpivot node within a Chunck Loop will do the trick. changing_format.knwf (32.5 KB)


gr, Hans

4 Likes

HansS it eorked perfectly thank you but I have just one little thing left:

If I have more than one catogery and not just revenue, how do I make the categories as columns as shown below: (I added GP next to revenue)

image**

image

1 Like

Hi @Menoufi

Tnx for your feedback. To add another Categorie, add another branch to your workflow.
changing_format_v2.knwf (55.1 KB)


gr. Hans

2 Likes

Hans THANKS A MILLION!

2 Likes