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;