I have used this component for similar tasks in the past (although not for your exact formatting), but it can’t change the actual Double display format in KNIME. It only creates a correctly formatted String column for display purposes.
Not sure i this is relevant, but I always make sure that any csv or other file reader uses the right separators in the Advanced tab in the corresponding reader. Usually the wrong choice means that the column in question is imported as a string, and there is a need for the String to number conversion.
@ssq I import a csv file and the column is set to ‘Number (double)’ and in advanced option the separator for thousands are set to dot (.) and for the decimals comma (,). But still the number is displayed as 1,210.78.
It seems to work fine on my end when I select “Icelandic” from the top options. This creates a “Text” column for display purposes only. Unfortunately there is no current workaround for altering the number datatype displays via KNIME’s internal rendering as you are building out a workflow. This will help for native formatting at output and review points.
@Daniel_Weikert first I will group data and then export the data to *.csv. Then import the data to either Excel or Power BI. So your advice to focus on change the format in Excel or Power BI sounds like a good idea.