Contrary to popular belief, working on files online can be hassle-free. Sure, some file formats might appear too hard with which to work. But if you have the right solution, like DocHub, it's easy to edit any file with minimum effort. DocHub is your go-to solution for tasks as simple as the ability to Consolidate Columns Object For Free a single file or something as intimidating as processing a massive pile of complex paperwork.
When it comes to a solution for online file editing, there are many options on the market. However, not all of them are robust enough to accommodate the needs of people requiring minimum editing capabilities or small businesses that look for more extensive set of features that enable them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing paperwork online more streamlined and easier. Try DocHub now!
so in this video were gonna take a look at how we can combine multiple files in a folder when the files have inconsistent table names and inconsistent column heading names so Ive got a folder here set up and its just got two files in it just as a simple example and Im just gonna open those both up and take a look at whats inside so heres file 1 and heres the data Im interested in importing and so youve got a column here called common and a column called a and the table name is data table and then weve got some other stuff in here that were not interested in and then in file 2 Ive got the same common full common column heading and Ive got another column called B and that table is called my data table and weve also got some other stuff in here so Im gonna close those two and Im just gonna copy this folder path containing those files and the usual way to import and combine files in a folder with power queries in the data tab go to get data and from file and from folder th