Combining tables

One of the phases of the project for the implementation of ERP information systems is retrieving data. These can be master data (partners, contacts, pricelists, etc.) or financial data. Most of them are retrieved from the company’s old information system, which is often exported as TXT or CSV files. Excel has a mechanism for retrieving entire files and manipulating data, which will be discussed in the text that follows …

The process of importing such files begins by going to the Data ribbon, and then running the New Query/ From File/From Folder option. Then select the folder where TXT or CSV files are stored. After we did this, Excel will show us the files that it was able to find in the next window. At the bottom of the window, you can see several commands that determine further actions: The Combine menu contains several options to combine (merge) tables into one, the Load menu contains options by which we only load the tables into Excel, and Edit is used to launch the Query Editor, where we can subsequently manually process the data.

If we just retrieved files, combining is done by selecting the Combine Files option from the Home ribbon of Query Editor. This option will launch a window in which it is necessary to specify the data we combine. Upon completion of the above operation, we will get one file containing the data from two or more of them.