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
Icon for Advocate II rankAdvocate II
6 years ago

You can specify specific colums during the Append step using Table.SelectColumns, as in:

 Table.Combine({#"Query 1", Table.SelectColumns(#"Query 2", "Column Name")})
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

         

  • BradZehr's avatar
    BradZehr
    Icon for Advocate II rankAdvocate II
    3 years ago
    = Table.Combine({Source, Table.SelectColumns(#"TableName", {"Column 1", "Column 2"})})
    • BradZehr's avatar
      BradZehr
      Icon for Advocate II rankAdvocate II
      3 years ago

      Sorry, that was multiple columns from the same table.

      • mhdilyas2008's avatar
        mhdilyas2008
        Frequent Visitor
        3 years ago

        look like it is from same table.

        i have multiple tables, anyway to archive.

        Appreciate your support.