Rayis Imayev takes us through the Union Transformation in Mapping Data Flows:
Recently I had a chance to work on a special case of creating a file where the first two rows were static and contained output table metadata (columns names and column types), assuming that further reading process would be able to explicitly identify each column data type and consume new file correctly in a single run.
Read on to see how Rayis solved this with Azure Data Factory.