Add headers to specific rows and output the results to multiple excel files

My data is have multiple entities and I want the output to split into multiple files, one file for per each entity (if there are 10 entities then it should output10 excel files). The tricky part is, in my data transformation I have to add headers at different rows in the data, so I have used union tool, hence headers appeared as exactly as I need, now that the issue is the results for all entities are grouped under headers and I have to output the results to multiple excel files at each entity along with the headers. Please suggest if possible with workaround.

Note below input files are header files, each header is slightly different from each other.

Output

Transformation

Dynamic Processing

Accepted answers

All comments

messi007

@ShravaniChanda,

Could you share a sample workflow it will help to provide the solution 🙂

Regards,

NikunjC

You mean to say 1o entities means 10 records in each file ? and you want each records to have different file as output with headers ? is my understanding right ?

ShravaniChanda

there is no limit as such for no of records, in can have any no of records, entity one may have 10 records , entity two can be 20, but all these entities should have same headers at end output files.

danilang

Hi @ShravaniChanda

You'll need to add File name column that is based on the entity ID. Append this to every row, including the header rows and use this to separate your output by this filename field in the Output config

Make sure to uncheck "Keep Field in Output" so that the Filename field doesn't show up in your output

Dan

ShravaniChanda

Hi Dan, I have same thought but the challenge is I could not able to appended headers for all the entities, what I have done was just appended the header by union tool, what I need this header should be repeated for all entities so that I can output into multiple files without missing headers.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703