Hey guys, I created a workflow to loop over tables in my database. So far, it looks like this:
Let’s say I have a table called employee which contains a primary key. Furthermore there is a table action and task that both have foreign keys on employee
My overall goal is to perform the same actions on each table, e.g. dropping duplicates, an then inserting the tables to a new layer of my database schema. However, in this new schema, foreign keys are enabled. Therefore, I must ensure that the loop first iterates over the employee table and then over the other.
I know that this might be solved my some numeric prefix on the table name that reflects the correct sorting, but is there a more automatic way of doing this?