Copy data from multiple cols in data factory

Question

Copy data from multiple cols in data factory

Lilac 80

Hello. I have an excel sheet in blob storage whose first 4 columns(A:D) have the same header names but different data as columns H:K. I need to copy the data using adf pipeline into a single blob output where the data from these 2 different col ranges will be appended. Any instructions on how to do it will be highly appreciated.

Sally Dabbah 5 Reputation points Microsoft Employee

2023-02-20T07:14:49.15+00:00

Can you please provide an example on your data set, what do you want to achieve, what is the output exactly?only appending columns to one sheet? do you want to save the output as .csv or as .xlsx file format?
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-02-21T11:39:39.1866667+00:00

Hi Kunal Chowdhury, Thank you for posting query in Microsoft Q&A Platform. Could you please elaborate your ask more with sample dataset if possible with expected result? That helps to understand the requirement better here and help you.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-02-22T09:09:40.43+00:00

Hi Kunal Chowdhury, Just checking if you get chance to share updates. Thank you.

1 answer

Your answer

Sally Dabbah 5 Reputation points Microsoft Employee

2023-02-20T07:14:49.15+00:00

Can you please provide an example on your data set, what do you want to achieve, what is the output exactly?only appending columns to one sheet? do you want to save the output as .csv or as .xlsx file format?
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-02-21T11:39:39.1866667+00:00

Hi Kunal Chowdhury, Thank you for posting query in Microsoft Q&A Platform. Could you please elaborate your ask more with sample dataset if possible with expected result? That helps to understand the requirement better here and help you.
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-02-22T09:09:40.43+00:00

Hi Kunal Chowdhury, Just checking if you get chance to share updates. Thank you.

Answer 1

Lilac 80

Hi Shaik Maheer,

The solution was achieved by using a mapping data flows and selecting individual ranges inside the select transformation. Finally these datasets were UNIONized and I used a copy activity to create the merged file.

ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator

2023-02-27T06:08:18.21+00:00

Thank you for sharing this. It helps community as well.

Share via

Copy data from multiple cols in data factory

1 answer

Your answer