When you need to apply a small tweak to the document, it should not require much time to Integrate table record. This kind of basic action does not have to demand additional training or running through manuals to understand it. Using the proper document editing tool, you will not take more time than is necessary for such a quick edit. Use DocHub to streamline your editing process regardless if you are an experienced user or if it is the first time using an online editor service. This tool will require minutes or so to learn to Integrate table record. The only thing required to get more effective with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to dedicate to document editing regardless of your previous knowledge of such tools. Make an account now and increase your efficiency instantly with DocHub!
[Music] hi in this video we will see how we can utilize our knowledge of the record types and setting a variable inside of a query that is going to be used in later parts of the transformation this is extremely useful in case we have unstructured descriptions of the table that most of the time appear above the table like in this excel example so as we can see we have an additional table above the table data that holds some pretty important information about the table so what we would like to see is that agent is inside of the table and repeated for every row in the table and the same as the part the same applies for the department export date and region so we need to somehow get these values to appear in rows of the table they are both in the same central sheet and now lets see how we can achieve that with the help of a power query so first lets connect it we will connect to the central sheet and lets go to transform data now we are sure that all the other experts will also have de