Forum Discussion
Compare Column Names from Multiple Sources
Hi there, I was wondering if someone could give me some ideas in creating a matching col names table. The ideia is simple, but i can't figure out. This table would have n columns, each co...
You could make a Table.ColumnNames(TableName) for each table, and then use List.Zip to so that each column name is in the same position in the list, like:
= List.Zip({ColumnList1, ColumnList2, ColumnName3})
Then make it into a table using Table.FromRows(TheListZipQuery)
--Nate