[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.
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?