Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to append only specified columns?

Hi,   I am appending several tables into 1 big table. I don't need all the columns so I have manually deleted the unnecessary columns after the append. Please can you tell me how to specify which c...
Need Help
BradZehr's avatar
BradZehr
Advocate II
3 years ago

To append selected columns from two tables:

= Table.Combine({Source, Table.SelectColumns(#"Table 1", "Column 1"), Table.SelectColumns(#"Table 2", "Column 2")})
mhdilyas2008's avatar
mhdilyas2008
Frequent Visitor
3 years ago

is this correct?

 

  • BradZehr's avatar
    BradZehr
    Advocate II
    3 years ago

     

  • BradZehr's avatar
    BradZehr
    Advocate II
    3 years ago

    I think you want more like this:

    = Table.Combine({Sheet1, Table.SelectColumns(Sheet2, ColumnName)})
  • mhdilyas2008's avatar
    mhdilyas2008
    Frequent Visitor
    3 years ago

    Thanks for your gr8t support.

    It did worked as expacted!!!