cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
uj_Gladiator
Regular Visitor

How to extract data from a list of records

Each record has these 5 elements, I want to convert this into a single table with column headers: visitorid, accountid, poll response, time and qual poll response. The data from each record should be a row in the table. 

Any idea on how to go about this? I have zero experience with M code, I was just trying to automate the ETL process for a dashboard and got stuck on this stage. Would be greatful to anyone who can help me out.

uj_Gladiator_1-1679657031084.pnguj_Gladiator_2-1679657040937.png

 

Thanks,
UJ

1 ACCEPTED SOLUTION
AlienSx
Solution Sage
Solution Sage

Hi, @uj_Gladiator 

    Table.FromRecords(
        List.Transform(
            Source[results], 
            each Record.RenameFields(
                _, 
                {
                    {"visitorId", "visitorid"}, 
                    {"accountId", "accountid"}, 
                    {"pollNumResponse", "poll response"}, 
                    {"pollQualResponse", "qual poll response"}
                }
            )
        )
    )

or just Table.FromRecords and rename table columns afterwards.  

View solution in original post

2 REPLIES 2
uj_Gladiator
Regular Visitor

It worked! thanks a ton

 

AlienSx
Solution Sage
Solution Sage

Hi, @uj_Gladiator 

    Table.FromRecords(
        List.Transform(
            Source[results], 
            each Record.RenameFields(
                _, 
                {
                    {"visitorId", "visitorid"}, 
                    {"accountId", "accountid"}, 
                    {"pollNumResponse", "poll response"}, 
                    {"pollQualResponse", "qual poll response"}
                }
            )
        )
    )

or just Table.FromRecords and rename table columns afterwards.  

Helpful resources

Announcements
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors
Top Kudoed Authors