I have two files I am trying to compare, each with the same heading structure in .csv files. Unfortunately they do not hav ethe date appended to them in excel.
Currently I have them in tableau as two different data sources since there are large number of files.
It's also aggregate data, so say the sales for the first file are $1,000, if we had another $100 in sales over the next week, this means the sales data in file two for the following week will be $1,100.
I've found some ways online, but they're a bit complex for me. What is the best and simplest way compare these two files on a weekly basis. Also, how can I make this easier for when I am dropping in new data for the following week?