When you want to apply a small tweak to the document, it should not take long to Expand record. This sort of basic activity does not have to require extra education or running through manuals to understand it. With the right document editing resource, you will not spend more time than is needed for such a quick edit. Use DocHub to simplify your editing process whether you are a skilled user or if it is the first time making use of an online editor service. This tool will take minutes or so to figure out how to Expand record. The only thing needed to get more effective with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to dedicate to document editing no matter your previous experience with such instruments. Create an account now and improve your efficiency instantly with DocHub!
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