CODEWITHSUNDEEP
sqlazureazure-data-factory
DataGirl
DataGirl

Reputation: 51

load two files in the same DB table with Azure Data Flow

How can i Load two files(csv) the same shemas into my sqlDatabase with AzureDatafactory flow?

I've created one flow with two input and the same output but i get just the one table data the other one (NULL) .

Upvotes: 0

Views: 60

Answers (1)

Leon Yue
Leon Yue

Reputation: 16411

As you said, the two csv file have the same schema, you could put them in same folder or container, make sure the container or folder only have the two files.

Then you could follow my steps:

My Container :

enter image description here

Data and file schema: enter image description here

Data FLOW Source dataset settings:

Just choose the container or folder, all the csv files in it will be chosen. When we preview data, the data of the two csv files will be merged together enter image description here

enter image description here

Sink dataset settings and data preview(the data will be inserted to the Sink table): enter image description here

enter image description here

Run the pipeline:

enter image description here

Check the data in Sink table:

enter image description here

Hope this helps.

Upvotes: 1

Related Questions