Forum Discussion

anmdf's avatar
anmdf
Regular Visitor
4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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]))