Hi my dear KNIME fellows
I have two tables I want to concatenate (have adjusted the headings already).
However, I want to add new rows to the table for items that are not yet in the list and update the existing ones.
Here is a screenshot (the rows marked in red should be added to the existing “products”):
I have also created an example workflow that has a daily updates table (table 1) and a master table (table 2).
update-existing-values-add-new.knwf (8.4 KB)
Thank you in advance for your kind help!
If you put you master table in DB, say SQLite, the node will do the work for you.
ok, thank you for the idea. But I do not have a db and don’t know how I should create one from within KNIME
I tried with an empty .sqlite file and the DB table creator node but it always returns an error
Is it as simple as adding a groupby node at the end? See attachment.update-existing-values-add-new_suggestion.knwf (10.2 KB)
@j_ochoada facepalm … I simply don’t know why I didn’t see this… Of course you are right, but I was so focussed on it happening “pre-concatenation” I oversaw this most obvious solution.
Thank you, that did the job!
Glad to help! Have a great day
For a case you interested in DB solution:
Update-existing-values.knwf (20.8 KB)
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.