Merge 2 CSV file

Vineet S 1,390

How to merge 2 CSV files in adf pipeline using sql queries or something

NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-19T07:17:09.5633333+00:00

Hi @Vineet S
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

hossein jalilian 10,825 Reputation points Volunteer Moderator

2024-08-16T16:23:18.1733333+00:00
Thanks for posting your question in the Microsoft Q&A forum.

You can use the Copy Data activity or Data Flow, depending on whether the files have the same schema or different schemas.

Add the source datasets pointing to the folder containing your CSV files. Use a wildcard file path to select all files you want to merge

In the Copy Data activity, select the source dataset with the wildcard path

Set the sink dataset to the location where you want the merged CSV file to be stored

In the Copy Activity settings, choose the Merge files option to combine the data from the source files into a single output file

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful
Please sign in to rate this answer.

1 person found this answer helpful.
NIKHILA NETHIKUNTA 4,600 Reputation points Microsoft External Staff

2024-08-20T13:00:06.15+00:00

Hi @Vineet S
Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer