In one of my workflows I had the following problem: When unioning two tables (same schema, same datatypes, however differently ordered columns) using the UNION processor, it seemed, my second input table was not appended, although it was not empty. There was no error message in the processor.
I therefore used the DOUBLE INPUT QUERY shown below, which totally scrambled the columns, but gave no error message either. When I explicitly state all the columns in the query, it works as expected.
So it seems column order plays a role in union, in the processor and in the query. So how would I order columns in OD in order to use the UNION processor safely?
SELECT s.* FROM secondInputTable s UNION SELECT f.* FROM firstInputTable f