6 Replies Latest reply on Dec 28, 2017 4:07 PM by Shinichiro Murakami

    Union Data from multiple excel files

    RAVI GURRAM

      I have Data in 3 excel files and each file has 20,15,10 columns and all these 3 files has only 8 columns same but with different names.Basically I want to union all the data and I am able to import data using custom sql query but I am interested to know if there are any other ways that I can import data to Tableau.

       

      Example -

      Sheet 1

      col x

      A

      b

      C

       

      sheet 2

      col y

      d

      e

      f

       

      I want output as

      a

      b

      c

      d

      e

      f

       

       

       

      Thanks

       

      Message was edited by: RAVI GURRAM