You realize you are using the proper file editor when such a simple job as Expand table attestation does not take more time than it should. Modifying documents is now a part of a lot of working operations in numerous professional areas, which is why convenience and straightforwardness are crucial for editing tools. If you find yourself researching tutorials or trying to find tips about how to Expand table attestation, you might want to get a more intuitive solution to save time on theoretical learning. And this is where DocHub shines. No training is required. Just open the editor, which will guide you through its main functions and features.
A workflow gets smoother with DocHub. Use this tool to complete the paperwork you need in short time and get your productivity to the next level!
[Music] hello in this video were going to show you how you can dynamically expand all the columns from a nested table this can occur when for example doing a merge in power query so here we have two tables these are the source tables so this is like effect table and then this we have another one which is a dimension and below we have two tables that were created with power query so first one was created with a classic merge so we just merged two tables we expanded and the other one is created with a dynamic type of expanding so now lets try to add additional columns lets add a column named type and lets say that this is type low so what will happen with regular merge if we refresh the regular merge will do nothing so at the at the period of merging when we did the initial merge we only had these three columns to expand so the code was hard coded in the script and after we added new column nothing happens while on the other hand if we have a dynamic type of expanding then when we c