Forum Discussion
anmdf
4 years agoRegular Visitor
Add column to a table column (from Source)
Hi,
Is it possible to add the sheet "Name" into the "Data" column as a custom column?
I wanted to do this because:
1. the sheet name is a distinguisher among the tables
2. the number of columns within 1 table varies (so I would do a Table.Combine formula after)
I'd really just want to insert that sheet name into the table before the Table.Combine function.
Thanks!
1 Reply
- AnonymousNot applicable
Hi anmdf
Add a custom column in Power Query Editor, to be your new Data column
= Table.AddColumn(yourPreviousStep, "yourNewDataColumn", (x)=> Table.AddColumn(x[Data],"newColumnName", each x[Name]))