Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi - I am new to Power BI / Power Query and all this so I will do my best to use the right verbage to explain my issue and what I need help with.
I have a column called "customFields", the column contains List which hold many Records and those hold values that I need from them. I am having trouble extracting the information from the records.
Each List will have many Records, but not always the same amount, and not in the same order, which makes me think I'd need some kind of if-statement?
I need to break them out by 'name' and pull in the 'value' from a Record. I'm not sure what would be the best method to complete this if it's creating a different table or a new column or what. Any help is seriously appreciated.
Solved! Go to Solution.
All you should need to do it extract the records from the lists using the double headed arrow at the top of the column. When you click this, choose the option Expand to New Rows
You then have a column of records and can repeat the process. Click the double headed arrow at the top right of the column and check the fields you want to extract (name and value?) and uncheck everything else. You can also uncheck Use original column name as prefix
You should now have the names and values from the records in separate columns.
Regards
Phil
Proud to be a Super User!
All you should need to do it extract the records from the lists using the double headed arrow at the top of the column. When you click this, choose the option Expand to New Rows
You then have a column of records and can repeat the process. Click the double headed arrow at the top right of the column and check the fields you want to extract (name and value?) and uncheck everything else. You can also uncheck Use original column name as prefix
You should now have the names and values from the records in separate columns.
Regards
Phil
Proud to be a Super User!
It is hard to explain without accessing to the data but I think You can use List.Transfrom to solve this problem
see this video which give you the idea.
https://youtu.be/W-hTgciYtew?si=I3SsBSr-L0uZemRS