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.
Thanks,
UJ
Solved! Go to Solution.
Hi, @Anonymous
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.
It worked! thanks a ton
Hi, @Anonymous
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.