When you need to apply a minor tweak to the document, it should not require much time to Consolidate columns accredetation. This type of simple action does not have to require additional training or running through manuals to learn it. With the right document modifying tool, you will not take more time than is necessary for such a swift edit. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it’s the first time using an online editor service. This instrument will require minutes to figure out how to Consolidate columns accredetation. The only thing required to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub can help you optimize the amount of time you need to devote to document modifying no matter your previous knowledge about such tools. Create an account now and enhance your efficiency immediately with DocHub!
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