Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ReplaceKeys

Owen Duncan|Last Updated: 4/19/2018

About

Returns a new table with new key information set in the keys argument.

Table.ReplaceKeys(table as table, keys as list) as table  

Arguments

ArgumentDescription
tableTable to modify.
keysA list with two fields: Columns and Primary. Columns is a list of columns that are keys. Primary is a primary key.

Example

Table.ReplaceKeys(Table.FromRecords({[A={[B=1], [B=2]}, C=1]}), {[Columns = {"C"}, Primary = true]})  
© 2018 Microsoft