1 2 Previous Next 17 Replies Latest reply on Dec 28, 2018 5:43 PM by Jeremiah Lewis Go to original post Branched to a new discussion.
      • 15. Re: Union of multiple data sources
        Benjamin Hicks

        A bit late to the party here.

        Would appending be the better solution here? To append in tableau you create an extract, then the append option shows up in the extract dropdown when you hover over the dataset. This allows you to load from a different dataset into the same columns. The drawback I've noticed when appending is there's nothing that lets you know which datasets you've appended afterward.

        • 16. Re: Union of multiple data sources
          Benjamin Hicks

          Alternatively you can use the union: wildcard (automatic feature). If the name of the files are similar, you can make tableau search a specified folder for a string that's in the file name (eg. file 1= Myfile1.xls, file 2= Myfile2.xls; would have wildcard string for workbooks = Myfile*). The major disadvantage here is file (and sheet) names should be similar since you cant specify file names otherwise.

          • 17. Re: Union of multiple data sources
            Jeremiah Lewis

            I suppose that works if you are dealing with files but tables in databases which are analogous to one another in their table and field names, it doesn’t so much.

             

            (edit by Chris McClellan : dodgy looking link removed)

            1 2 Previous Next