Hello,
I want to connect to a Database and then execute a SQL depending on whether a table has been changed.
My plan is to run a SQL executor to check if table1 has been changed depending on the date and compare it to table2. When the first table has a newer date(has been updated) I want to update the second table with the new data.
If it hasnt been updated, the workflow should do nothing.
How can I change the output of the SQL Executor to a TRUE/FALSE string so I can use the string for a IF Switch that determines it has to run the SQL script that updates table2?
Or is there another way of doing it?
Greetings Oli