How to Dynamically take new tables to already existing workflow

[Nirvisha]

I have a workflow that has 12 tables i.e., each table is each month.Now I need to dynamically add the new month table to workflow as soon as it enters the database.I'm using oracle db

Can anyone please help me with that.

[cjaneczko]

Its hard to tell without knowing the names and structures of your tables. But you would likely want to start off by using the Dynamic Input tool. Set the tool up to pull from an existing database and have it update the Table name it pulls from. Select the Modify SQL query radio button and add a new condition to update the string that contains the table name.