2 Replies Latest reply on Jan 9, 2019 8:20 AM by Diogo Henrique Guilhen

    Merge/Append 2 Excel Sheet

    shanmuga prabhu

      Hi All,

       

      I Have 2 different excel sheet with same column name , I need to merge the 2 files

       

      Example

      File1

      Col A , Col B

      1, 2

       

      File 2

      Col A , Col B

      4, 5

       

      Thanks

        • 1. Re: Merge/Append 2 Excel Sheet
          Vikram Gokhale

          have you tried creating a UNION ?

          • 2. Re: Merge/Append 2 Excel Sheet
            Diogo Henrique Guilhen

            Hello there!

             

            plase read this article:

            Union Your Data - Tableau

             

             

            Union tables manually

            Use this method to manually union distinct tables. This method allows you to drag individual tables from the left pane of the Data Source page and into the Union dialog box.

            To union tables manually

            1. On the data source page, double-click New Union to set up the union.
            2. Drag a table from the left pane to the Union dialog box.
            3. Select another table from the left pane and drag it directly below the first table.Tip: To add multiple tables to a union at the same time, press Shift or Ctrl (Shift or Command on a Mac), select the tables you want to union in the left pane, and then drag them directly below the first table.
            4. Click Apply or OK to union.

             

             

             

             

            Best regards.