Table.ReplaceKeys
Updates the keys of the specified table.
In this operation, the keys for a table are changed using Power Query M. The existing keys of a table are replaced with a new set of keys. The process involves creating a table from records, adding new keys to the table, and then replacing the existing keys with the new keys. The final output is a table with the updated keys.
The table is initially created with records containing Id and Name columns. The Id column values are used as the keys for the table. The new keys are added to the table using the Table.AddKey function. The existing keys are then replaced with the new keys using the Table.ReplaceKeys function.
The result of this operation is a table with the updated keys, while maintaining the original records of Id and Name.