If table is in DB, update it, if not - create

Hello all,

I want to create a table in DB using “Constant File” (data in this table always constant):

ID Responsible
1 Bo
2 John
3 Annah
4 Roger
5 Frank.

After that I should update this “Constant File” by using “Update File”(data in this file is changed daily), which consists of data that should be changed in “Constant File”:

ID Responsible
2 Leon
5 Chordi

So, final table should be (based on “ID” I assigned new values for column “Responsible”):
ID Responsible
1 Bo
2 Leon
3 Annah
4 Roger
5 Chordi

All this should be done in one workflow. For the first time when I execute this workflow all works good, because:

  1. I create a new DB Table “Constant File”
  2. then I update it with the help of “Update File”.

But when I want to execute this workflow for the second time, it is a problem, because
I should not do step 1. , because this DB Table “Constant File” is already in database. I should start with step 2.
But how can I do it in the same workflow? So, for the first time I should use step 1., but when I want to execute the workflow for the second time, I should use only step 2.

Please, explain me the approach how I can do it.
Thank you!

Best regards,
Ram

Look at

Node for the task.

1 Like