Hi, i have an excel sheet with over 27.000 customers with postal codes. E.g.: A: Name B: Postal code 1 Customer X 35679 2 Customer Y 76521 I want to make the postal code from 35679 to 35 and from 76521 to 76 How can I do this? I need this for k-means later. Thank you

Hi @Fatih97 Welcome to the KNIME Forum. Theres several ways to do this in KNIME. You could use a string manipulation node. Example attached! [image] Truncate String – wkhan Solutions for data science: find workflows, nodes and components, and collaborate in spaces. Regards, Wali

KNIME Forum Archive

Clustering data after postal codes

KNIME Analytics Platform

← previous page

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled