Hi,

I have a project where I need to transform input file and put it into monthly files directory (each day new file comes).
Then each day I need to run transformation that takes all files content (original files stay) and produce one consolidated file (month file... this file will contain all day files across the month then new month new one is created). This consolidated information file will be overwritten each day.

The desired model is that users will have access only to this consolidated file where they can modify some records.
But the problem is this file should be updated each day; appended new rows from daily files and protect old rows with information modified by users.

I'm about to abandon this idea and let people work on day files and consolidated file is just to read yet maybe you have some idea how to safely obtain the ideal model?

Regards,

G.