Hi,

Daily file is the daily input and main file is the database which contains all the files till date.

I need to check the data in daily file with the data in the main file. if there is duplicate color column 1 with the count of how many times duplicated.

At the end of the day, i need to append the contents from daily file to main file. This happens every day.
Layout is same for both the files.

Main file acts as a database.

-Sindhuja