Question:
How can I use a Query to retrieve data from two tables alternately if they have the same columns structure?
Solution:
To do so, you must edit the Query’s SQL:
SELECT FieldName1, FieldName2
FROM <%TableName%>
Then, via E3 scripts, use SetVariableValue method to attribute the name of the table where the Query must retrieve its data to TableName variable.
