Hello All,
I am working on a monthly massive Sales report with consist of around 400+ columns and 60k+ rows of data. This report required significant manual changes every day. I generated the report from Alteryx itself, and then reconciled it with various other team data, and make manual changes, in rows, columns, and even specific cells, which required a high level of manual intervention and time. To beat this manual work, I started to consolidate all the manual changes in one template and replace the data with Raw data, but the problem is that this report is month over month, and sometime prior month data was changed which arise problems in the data. So I need help building a model to check, track and update the changes, between files. Please see the below -
I have two files, Raw Data and Updated Data. I need a Model that - First, checks all the columns of data from Data Raw file to the Updated Data file and provide the results which are different in both files (kind of error log). Secondly, replace the Updated Data File data from the Raw Data file in cases of a difference in the value, row, or column.
I have attached the sample data and examples.
