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!
1 Like
Look at
If you put you master table in DB, say SQLite, the node will do the work for you.
1 Like
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)
5 Likes
@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!
1 Like
Glad to help! Have a great day
For a case you interested in DB solution:
Update-existing-values.knwf (20.8 KB)
system
Closed
February 27, 2019, 7:34pm
8
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.