Forum Discussion
Solved
How to Expand two nested table column simultaneously in Power Query
Hi community expert, while struggling from 2-3 days how to expand two columns simultaneously containing nested table. any help will be appreciated. Attached are screenshot have table. I want to expand both columns same time to avoid duplication in data set.
NewStep=Table.Combine(Table.ToList(PreviousStepName,each Table.FromColumns(Table.ToColumns(_{0})&Table.ToColumns(_{1}),Table.ColumnNames(_{0})&Table.ColumnNames(_{1}))))
2 Replies
NewStep=Table.Combine(Table.ToList(PreviousStepName,each Table.FromColumns(Table.ToColumns(_{0})&Table.ToColumns(_{1}),Table.ColumnNames(_{0})&Table.ColumnNames(_{1}))))
Hi, the Solution work perfectly. if i get the code in piece wise I will learn a bit more. Thank you soo much.
