then you should just remove the “String to Number”. But than you would have the truncated PLZ-Codes in String format, but that seams to be what you want?
By the way clustering by postal code is not trivial as it seams (when you are located in Germany,
Yes, I am in Germany.
My goal is to find out, where the most customers of a company are to open a new location. I have an excel sheet with over 20.000 customers and their postal codes.
I want to make 3 oder 4 clusters, to see where in germany (north, east, south, west) the most of the customers sit. Then I will plot this with a scatter plot and make a histogram.
Hi @Fatih97 ,
maybe this workflow can help you 20220322_zipcodes – KNIME Hub
It reads the file with postal codes and lat/lon on Github, then it calculates the centroid for each code (a lot of codes are shared between many towns) and then it joins the resulting table with the customers data (a test table with just zipcodes).