Please select the source file to text and navigate to the folder where all your files are present. Select one of the files as data source and you will be able to find all the files in the folder once the connection has been made. Then you can use the union feature.
Also refer this link for your convenience.
Hope this answer your question.
Hi Akshay - thanks for your response. I tried doing that but it messed up the file data. Also, it doesnt list the other files in the folder. See the snapshot below.
My steps - Connect to Data Source - Text Files - Change option to "All Files" - Selected the excel file.
Also tried this => Connect to Data Source - Other files - Selected the excel file. I get the same view as i pasted previously (no list of other files)
1 of 1 people found this helpful
The union files option does not work with Excel, it works with CSV files.
You won't be able to interpret an Excel file as text in the way you've done it as an Excel file is not a plain text readable file type.
You have a number of options;
1. Export all Excel files to CSV and connect to those
2. Add new tabs to an existing Excel file and union the tabs within a file
3. Manually consolidate your files into one tab in Excel.
I totally agree with Tom.
I guess the first option will be useful.
Hi Tom - yes, unfortunately I did the 3rd option for now as I had only 3 files to work with currently. But I will keep this in mind.
Thank you very much for this. Good day!
Please mark the answer as correct to close the thread.