I would like to write a function that firstly finds duplicates on each row and replaces this with a value from a look up table (plus checks that the new insert doesn’t cause any new duplicates). For blank values it should replace these with a value from the same look-up list, again without creating any duplicates on the same row.
What’s the best way of setting this up in KNIME? Thanks in advance for your help!
Would you please provide a sample dataset including your lookup table? And please explain it further that how these blank and duplicate values should be replaced.
If there are a duplicate value on the row it should be replaced by a value from the look-up table as long as the inserted value from the look-up does not already exist on the row
If the row contains blank values it should be filled with random values from the look-up table as long as none of the inserted values are already present on the row
The operation and 1 and 2 should only be applied to the first four value columns (Split Value 1, Split Value 2, Split Value 3, Split Value 4, Split Value 5).
The desired output should be five unique values for each row consisting primarily of values from the original table but if duplicates or blanks are featured on the original list when values from the look-up should be used
Sorry but the workflow you have shared contains one Excel reader node which is not executed.
And the xlsx file is a sales dataset. I couldn’t understand what you want to do with it.
Regarding your question, you may provide a dataset which has duplicate values in some columns of a same row (I guess) and a “look-up” table" which provides the values which can be used instead of those duplicates.