[resolved] How to merge 2 text files with different schemas

Five Stars

[resolved] How to merge 2 text files with different schemas

Hi there, i have 2 delimited files coming in daily that needs to be merged into a single flat file, but their schemas are different.


THe 2 files are Item and Department sales, but they have different schemas seeing that 1 contains item data and the other department data.
Any idea on merging those 2 files would be greatly appreciated.

Accepted Solutions
Five Stars

Re: [resolved] How to merge 2 text files with different schemas

I found a similar post where this was already resolved
https://www.talendforge.org/forum/viewtopic.php?pid=164939
but thanks for feedback sankalp

All Replies
One Star

Re: [resolved] How to merge 2 text files with different schemas

Your post is lacking the basic information like what is the schema of the files. What is the output that you are expecting. On what basis do you want to merge them?
Five Stars

Re: [resolved] How to merge 2 text files with different schemas

I found a similar post where this was already resolved
https://www.talendforge.org/forum/viewtopic.php?pid=164939
but thanks for feedback sankalp