Concatenate 2 files with different schema in Data Factory

Question

I have a CSV file that needs to be that need to be concatenated with the results of a pipeline. Essentially the first CSV file acts like the metadata for the pipeline file, so they do not have the same schema. I can't seem to merge them together using the standard tricks (I am not a SQL native).

For example:

File 1 (3 columns):

Location,Date,Version

Oakland,01/01/2024,1.0.0

CSV results of my process (5 columns):

Name,Description,Price,Attribute,Count

WidgetA,FancyWidget,$1.00,Round,3

WidgetB,LessFancyWidget,$4.50,Square,212

My output should look like this

Output File:

Location,Date,Version

Oakland,01/01/2024,1.0.0

Name,Description,Price,Attribute

WidgetA,FancyWidget,$1.00,Round

WidgetB,LessFancyWidget,$4.50,Square

I hope that makes sense.

Answer 1

Below link can act as a reference to concatenate the data within a same csv file :

https://stackoverflow.com/questions/66403101/need-to-add-header-and-trailer-record-in-a-csv-file-azure-data-factory