2 Replies Latest reply on Nov 29, 2018 12:05 PM by Ajinkya Sirsikar

    Data union from different Excel files

    Ajinkya Sirsikar

      Hi All,

       

      I am currently working on 5 different excel files for different month which contain the same columns. I want to union these files and then start working on tableau.

       

      I tried to copy all my data from the different files and put it in one workbook in different worksheets and then created a new union and dragged all the sheets there. I referred to this link Union Your Data - Tableau

       

      I did this manually and since it is a lot of data it took me a lot of time. Is there any way we could combine the data from all the 5 different files rather than creating a new consolidated file in excel by a simpler way in Tableau itself?

       

      Please refer to the sample data files below.


      Thanks,

      Ajinkya