Extract Two Column from Master Table

[Anonymous]

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.

[amitchandak · Accepted solution]

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]

thanks