I am trying to create a workflow when I would like to open multiple tables and concatenate them. The issue I am running into is that I don't know whether the tables will be available. As an example let's assume I may have up to 8 tables total. Let's call them table1, table2... table8.
The workflow I created assumed all tables exists, but if I remove one or a few tables it generates the error since the table/s cannot be found.
For open table step I have found a solution by adding action before step that will check if the table exists
Try(
Data Table("table1");
tableExist = 1
,
tableExist = 0
);
Though I am not sure how to implement similar solution when I am trying to concatenate all available tables.