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.