4 Replies Latest reply on Feb 23, 2017 9:40 AM by Sherzodbek Ibragimov

    Union different excel files?

    Maximus Decimus Meridius

      I have multiple excel files. I know for csv files it's easy to join because when you do text data source it shows all text files in the directory so you just drag and drop. But with excel, it only shows the tabs in the file selected. The way the data is coming to me it's in separate excel files (with same headers), and getting it in different tabs is not an option...is there a way to union multiple excel files together? I have one file for each year (2017, 2016, 2015 etc) and just want to combine them