It works! Thank you so much for the time you have taken - you are the best! Regarding column “Year” and column “month” which is now in separate columns - is it possible to merge them info a column called “date” and instead of 2021 Jan, 2021 Feb, 2021, Mar - show something like e.g. Jan-21. Feb-21 and Mar-21?
Sure. There are a few ways you could tackle this, and one way is with a String Manipulation node. I’m assuming that all the dates are in the 2000s, and that you don’t need the resulting string as a Knime Date&Time format.
You want to repalce the “20” with “-”, but the String manipulation node only works with strings, and not integers. The fist step is to convert the year to a string with:
string($Year$)
Next you can do the replacement:
replace(string($Year$),"20","-"))
Then finally, add the month to get the final expression:
join($Month$,replace(string($Year$),"20","-"))
If you put the String Manipulation node before the Table Manipulator node, you can do all the cleanup (renaming columns and removing unneeded columns) at the end.
Regarding replacing specific cell values I used “String manipulation” - is it possible to replace more than one expression in each “nood/tool” I used: replace($Type$, “Net sales”, “Nettoomsättning”) and replace($Type$, “Cost of goods sold”, “KSV”) and replace($Type$, “Other income”, “Övriga intäkter”) in separate noods/tools and want to lean a more efficient way of working.
I have a question regarding some efficient way of index/matching in missing values (A, B and C) in column “Discount Group” based on another column “Customer codes”.
I’ve attached an example below where I have the raw data sheet.
I was thinking of creating a separate sheet “mapping table” where all duplicates are removes and can therefore we used to match each customer code/discount group?