7 Replies Latest reply on Jul 23, 2018 4:18 AM by Stefan Redlich

    Union multiple Excel sheets from different workbooks stored on Dropbox

    Stefan Redlich

      Hi,

       

      I am left clueless with the following problem:

       

      There are five Excel Workbooks stored on Dropbox with a sheet "RawData" which has the same structure in every workbook but of course different data.

       

      Now I am trying to create a data source with Tableau that unions all 5 of those sheets (I will add a calculated field to break down the origin of that sheet). However, I have no idea how to do that. I can join two workbooks but that's about it. Is there any way to union sheets across more than 1 workbook with Tableau? Tableau Prep can also not help right now because it does not have a Dropbox connector as far as I know.

       

      Any help much appreciated!

       

      Best

      Stefan