How to merge 4 individual tables in excel sheet and generate single flat file using Azure Data Factory

Sai Krishna Budharapu 0

Hi Team,

I am trying to convert flat file from unstructured excel file. below is the reference screenshot which currently im working on. I want to merge the 4 tables which are highlighted in thick border and to make it a flat file converting column B as a columns and bold ones. Everything should be done using Azure Data Factory.

User's image

the output file looks like the below sample image. Could someone helps me to provide the solution for the above scenario

User's image

QuantumCache 20,346 Reputation points

2023-06-22T04:02:12.9866667+00:00

Hello @Sai Krishna Budharapu, thanks for reaching out on this forum!

Did you try any transformations such as Conditional Split transformation and use it to split the data into 4 separate streams based on the table headers.
Sai Krishna Budharapu 0 Reputation points

2023-06-22T07:14:24.8733333+00:00

Yeah I used Conditional Split transformation as well...As the input sheet doesnt have proper headers that transformation is not working. what expression i need to write to split the specific columns and rows
QuantumCache 20,346 Reputation points

2023-06-28T02:39:38.66+00:00

Hello @Sai Krishna Budharapu, Could you please attach sample files to the question?

any clarity on the each table will be helpful, as a text or file instead of image!

Share via

How to merge 4 individual tables in excel sheet and generate single flat file using Azure Data Factory

Your answer