Forum Discussion
how can i edit table?
i have json similar this 1 { participants : [{name : 'aa', email : 'bb'}] } 2 { participants : [{name : 'ac', email : 'bd'}, {name: 'bg', email : 'ch'}] } 3 { particip...
say the column name is "participant", try this
=Table.TransformColumns(TableFromJson,{"participant",each let tbl=Table.Combine(List.Transform(_,Record.ToTable)),header=List.Accumulate(tbl[Name],{{},[]},(x,y)=>let r=Record.TransformFields(x{1},{y,each _+1??1},2) in {x{0}&{"participant"&Text.From(Record.Field(r,y))&"."&y},r}){0} in #table(header,{tbl[Value]})})