Hi All - would appreciate some help for the following:
I currently have the data like this:
And I would like to transform it into this:
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)
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)
Tnx for your feedback. To add another Categorie, add another branch to your workflow.
changing_format_v2.knwf (55.1 KB)