You are here: Help Topics > Customization > Calculation > Shuffle Table Columns Action

Shuffle Table Columns Action

Event Function: ShuffleTableColumns

The Shuffle Table Columns action reorders columns in a table.

Using the Events tab

Under Enter Example

Run Skip Condition

If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.

Table

Type the table name placed in quotation marks.

"T1"

New Column Order

Type the order in which you wish the columns to be arranged. Separate the columns by commas and place the column numbers in quotation marks.

"2,3,4,1"

See the following topics for conditions placed on merged squares and keep-togethers in tables.

Shuffle Table Columns

Reordering columns in a table

Syntax (if entering it in the Equation bar)

ACTION("ShuffleTableColumns","expr1","expr2")

Where

expr1 = entry under Table

expr2 = entry under New Column Order

How the example will appear in the Equation bar

ACTION("ShuffleTableColumns","T1","2,3,4,1")

Related Topics