Expanding a List into columns for Parent Records when List has variable content per parent record
I’m looking for help to systematically extract information from sub-dictionaries provided by an webAPI. In PowerQuery, these subdictionaries appear as Lists within their parent records. If there is a Key-Value pair in that list, I’d like to extract the value into cell within a named column representing the associated Key. This cell would effectively be a value for the parent record.
Getting the next value of the same user if the type is “no type”
I need your assistance with this. (Power BI or Excel)
Powerquery, convert list to row-wise values
I have the following code, with the following JSON structure: (the elements are lists)