QUA_DESHUFFLE

De-pseudonymizes data and produces its original counterpart. This function is the opposite to QUA_SHUFFLE and is used to unhide shuffled data.

Syntax

QUA_DESHUFFLE ( expression, seed )

Arguments

expression

Is an expression of the supported type. For the details of supported types check _QUA_SHUFFLE_ description.

seed

Integer value of seed to use.

Return types

Returns the same type as expression.

Remarks

QUA_DESHUFFLE has specific behavior when a date is concerned:

  • always produces the same age;
  • respects leap years;

Example

SELECT qua_deshuffle(cast('4ef05e0d-7774-d86e-be4c-7ccf216ef1e0' as uniqueidentifier), 123456) as OriginalGuid;