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:
- I create a new DB Table “Constant File”
- 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