Skip to main content

Shuffle Masking

The Shuffle masking changes the order of values within a table column. In other words, the values in the column are "shuffled" so that each value ends up in a randomly assigned row that is different than the one it started out in while the other columns stay where they are. If there are fields/column values that need to remain associated with the respective column values being shuffled, you can shuffle them together as a unit so that they maintain their relationship.

This masking is suitable for:

  1. Preserving statistical information, such as a column's minimum, maximum, sum, or average value.

  2. Ensuring that the masked data will not violate business rules at the database or application level. (Since the data is repositioned rather than replaced, the values are guaranteed to meet all).

  1. The Columns available to shuffle section displays the list of all the columns that are available for shuffling in consistent to the selected column to shuffle.

  2. The Columns to be Shuffled section display the list of column name(s) which needs to be shuffle masked.

To add a column in the Columns to be Shuffled panel, whose value is used for masking, use drag and drop feature. Similarly, to remove a column from the Columns to be Shuffled; use drag and drop feature. The extra columns selected to shuffle consistently would get green highlight in the Apply Masking panel as no other masking can be applied now to it.

E.g., with reference to below image, if you want to shuffle the data in State column of the Employees table then specify one or more columns whose values are used for masking the data in State column.

We have opted for city and country columns in the Columns to be Shuffled panel.

In the below image, on executing the task, the data in the target database is shuffled. For Instance, the Country, State, and city for emp_cd = 100 was originally US, London, Acton. After applying Shuffle Mask, the values for these columns are changed to UK, Delhi, CP. Similarly, data for remaining records are also shuffled while other columns maintain their position.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.