Hi, KNIME beginner here and I really need your help please!
I am wondering if we are able to push values through flow variables into a Table Creator node so that we can input mapping data from there.
Say I have a list of data set that has multiple and duplicated value for âSeasonsâ.
This list can contain typos and incorrect data that I would need to amend.
I used the Groupby node to find all Unique values of âSeasonsâ within this dataset.
I was wondering if there is a way in KNIME to auto populate Table Creator node with this set of unique values from the Groupby Node.
What I am ultimately trying to achieve is that I could push the unique values into Table Creator to which user can then manually input a mapping table according to the unique values that was found in the dataset.
Example:
My issue is that there are many errors within the dataset and I cannot be certain what kind of typo errors can occur and therefore the mapping will be different every clean.
So if there is a way for KNIME to auto populate the table creator node with the current unique values per this current dataset, it would help the user do a âreplace allâ appropriate to this dataset (that may be different month on month).
Please send some help!!!
Appreciate yall!
Thank you!
Controlling Table Creator node with flow variables is a bit cumbersome and I would suggest to stay away from it. Especially when there are other (better) options for your use case.
So if I got your process right you should first get unique values and for it you can use GroupBy node as you did but also Duplicate Row Filter node (which is more intuitive and has a bit more options if youâll need it in future). Also after it you wonât need Column Filter node probably. Then you need to present users with option to input correct mapping for season column. Node you can use here is Table Editor. Missing functionality in it is that you are unable to create new columns (and rows as well I think) with it so you should create it before and itâs best to be empty. This you can easily do in Table Creator node but as your list probably doesnât come from it see here how to easily add new column with missing values to your data table (missing values in KNIME are denoted as red question marks).
I have a main data source that has multiple rows and columns of data.
So part of my cleaning is trying to iron out the typos within the Season column.
My current workaround is that I extract out Unique values within the main data set using Groupby Node.
Then I have the users open the Group Table to copy out the unique values.
And then paste it back into Table Creator Node.
Then I have it mapped back into main data using Joiner Node
I was just thinking if there is a way to automate or auto-populate the Unique values into Table Creator so that Users can avoid the manual copy and pasting of values to have it replaced.
Do you have any suggestions for that?
Or would Table Editor be able to do that as well?
I tried Table Editor but it would mean that user can only change a few values (if we use Duplicate Filter Node to filter unique values) or they would have to go through rowsssss of data to clean it manually. Otherwise, Cell Replacer, would also mean that they would need to manually input the âold valuesâ and then the new values similar to my current workflow. Am I doing this correctly?
so Table Editor should be used to enter correct season. And with connecting it to table that has unique values and one empty column youâll get automation you are looking for. Cell Replacer is here just for mapping (instead of Joiner).
