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
Advocate II
3 years ago
= Table.Combine({Source, Table.SelectColumns(#"TableName", {"Column 1", "Column 2"})})
  • BradZehr's avatar
    BradZehr
    Advocate 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.