Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extract Two Column from Master Table

Hi Experts

 

how would you extract just two columns from a master tables. Master table assume has columns A:F but i want to creat another table (no unique records in new table) showing just columns A and B only from the master table.

  • Try like

    New table = selectcolumns(Table,"A",Table[A],"B",Table[B])
    New table = summarize(Table,Table[A],Table[B]) // This will give distinct values

     

     

2 Replies

  • Try like

    New table = selectcolumns(Table,"A",Table[A],"B",Table[B])
    New table = summarize(Table,Table[A],Table[B]) // This will give distinct values

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      thanks