Expand/Collapse all
Hash256 - script and chart function
Hash256() returns
a 256-bit hash of the combined input expression values. The result is
a 43-character string. Hash values are useful for masking personal identifiable information (PII), such as customer names, social security numbers, or account numbers.
Syntax:
Hash256( expr{, expression})
Return data type: string
Example: Chart expressions
Hash256
( 'abc', 'xyz', '123' )
Returns 'MA&5]6+3=:>;>G%S<U*S2I:`=X*A.IO*8N\%Y7Q;YEJ'.
Hash256
( Region, Year, Month )
Note: Region, Year, and Month are table fields.
Returns 'G7*=6GKPJ(Z+)^KM?<$'AI.)?U$#X2RB[:0ZP=+Z`F:'.
Load script and results
Hash_256:
Load *,
Hash256(Region, Year, Month) as Hash256;
Load * inline [
Region, Year, Month
abc, xyz, 123
EU, 2022, 01
UK, 2022, 02
US, 2022, 02 ];
Result
Region
Year
Month
Hash256
abc
xyz
123
MA&5]6+3=:>;>G%S<U*S2I:`=X*A.IO*8N\%Y7Q;YEJ
EU
2022
01
B40^K&[T@!;VB'XR]<5=//_F853?BE6'G&,YH*T'MF)
UK
2022
02
O5T;+1?[B&"F&1//MA[MN!T"FWZT=4\#V`M%6_\0C>4
US
2022
02
C6@#]4#_G-(]J7EQY#KRW`@KF+W-0]`[Z8R+#'")=+0