Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to MergeContent with single header from multiple files.?

avatar
Super Collaborator

I am using MergeContent processor to Merge 20 small .csv files in to one file. All of them are similar with same header.

The files are getting merged successfully but when i opened the destination file i am seeing 20 headers (one header for each file). is there some setting that i can do where i can have header only once in the Merged file.?

1 ACCEPTED SOLUTION

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
5 REPLIES 5

avatar
Expert Contributor
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Contributor

Can't understand. Can you send overall source code for it.

avatar
Explorer

The answer @mpayne is correct. Only that setting the header in MergeContent doesn't include a line break at the end of header and the records. So as EL is supported please include line break at the end.

avatar
Super Collaborator

Awesome ,thanks. that worked.

avatar
Super Collaborator

@mpayne, is there a way i can check for headers from CVS files and merge all files with similar headers and route other files to failures.??