Forum Discussion

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago
Solved

expanding column with record and list

Hi All,

 

i am stuck in a problem following is a column i have i cant expand it because it has List and Record in it.

 

list is the combination of a lot of records and i tried converting everything to list and then expand it..it didnt work.

 

following is the mquery

let
Source = DocumentDB.Contents"Source"),
Expanded1 = Table.ExpandRecordColumn(Source, "Document", {"id", "details"}, {"Document.id", "details"}),
Expanded2 = Table.ExpandRecordColumn(Expanded2, "expanded 1", {"detail"}, {"detail"})
in
Expanded2

 

any help is appreciated.

 

i saw another post regarding this but for that the list was empty for me list and record has records

2 Replies