You know you are using the proper document editor when such a basic job as Extend table record does not take more time than it should. Modifying documents is now an integral part of a lot of working operations in different professional fields, which explains why accessibility and simplicity are crucial for editing instruments. If you find yourself researching manuals or trying to find tips on how to Extend table record, you may 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 instrument to complete the files you need in short time and take your efficiency to the next level!
whats up guys Parker here I have a very useful video today showing you how you can expand record columns dynamically in power query I say dynamically because if youve ever expanded a record in power query before you probably went through the UI which hard codes column names so this video is going to teach you how you can create make it dynamic so youre not specifying column names to expand instead it will expand all of the columns that are returned in your data so in this example Im using a sample API call that returns some null values and some record values so you see out of the eleven records here three have values in them so if you have expanded columns in the past you probably went through the UI by clicking these little two arrows and it specifies all the columns that you have available so we can click OK and this is how it normally expands so youll get all of the different columns you see that there are no values for those records that had no records but the but the rows th