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
mhdilyas2008's avatar
mhdilyas2008
Frequent Visitor
3 years ago

can you please give example here

fatcing the specific column data from multiple tables

BradZehr's avatar
BradZehr
Icon for Advocate II rankAdvocate 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
      Icon for Advocate II rankAdvocate II
      3 years ago

       

      • mhdilyas2008's avatar
        mhdilyas2008
        Frequent Visitor
        3 years ago

        Thanks for your gr8t support.

        It did worked as expacted!!!

    • BradZehr's avatar
      BradZehr
      Icon for Advocate II rankAdvocate II
      3 years ago

      I think you want more like this:

      = Table.Combine({Sheet1, Table.SelectColumns(Sheet2, ColumnName)})