0 Replies Latest reply on Jun 21, 2017 8:32 AM by Brian Fischer

    Comparing Data from 2 or more different sources

    Brian Fischer

      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?