Randomly reorders the records of a table.

Description

The Shuffle function reorders the records of a table.

Shuffle returns a table that has the same columns and number of rows as the argument.

Syntax

Shuffle( Table )

  • Table - Required. Table to shuffle.

Example

If you stored details about playing cards in a collection named Deck, this formula would return a copy of that collection that has been randomly shuffled.

Shuffle(Deck)