I am using Tableau Desktop 10.1 version. I have more than one data set (excel workbooks) which I need to append in Tableau Data Source tab. All the excel workbooks have same sets of columns. I can place them one below the other in excel and load in to tableau. But my objective is to bring them one below the other in Tableau data source tab itself. I have successfully tried appending the data sets in tableau worksheets, but I wish to know if the same can be done in the Data Source tab. I have also tried using "New Union" functionality with the various available join types, but the data does not get appended as required. Is there any other way through which I can append the data one below the other? Thanks.
