Data Cleaning
Hi all, I am new to KNIME and would like to ask a question in regards to data cleaning.
I manage to clean from the raw data up to this point. (refer image)
The issue is I want to create a new column (left side of Program Name) titled RK Centres with the respective name.
How do I extract the kindergarten name (from New Column) as well as removing the first 3 code name⦠so from JSI - REAL Kids Setia Indah to only REAL Kids Setia Indah.
There are 40 different kindergartens centre.
I will explain in further if it is confusing⦠Thank you in advance.