Skip to main content

PQL47 (PQL Function Library - CPM 4.7)

STRINGHASH

Applies to: CELONIS 4.5 CELONIS 4.6 CELONIS 4.7

Description

STRINGHASH computes a cryptographic hash of a string, encoded using base64 encoding. The returned hash may change in the future.

Supported input column types: STRING

Output column type: STRING

Output Hash Size: Currently 39 characters. Hash quality: 234 bits

Syntax
STRINGHASH ( table.column ) 
NULL handling

If the value is NULL, the result is NULL as well.

Example

[1] In this example, the STRINGHASH function is applied to some strings:.

Query

Column1

STRINGHASH ( "Table1"."Column1" )

Input

Output

Table1

Column1 : STRING

'LaTeX'

'PQL'

'Python'

'a '

''

''

null

''

Result

Column1 : STRING

'cScbqCayViK/QywnqgPUP9MiW6rjPelytv7oRtJ'

'vD9Rq2vcAOaQdT0A2/OV9yyjjYX+HrdfrlUVU02'

'o5cGXGnMp4ug1936A/VL/R2VA19PEgOVYcw80v2'

'zYfBymiqp8llFFfzVKe85y2JUo6XDJqQ4/IfScg'

'6CRFGgx7qL8rK9qOomRISAfWysVHcpaC/k1WC1C'

'aSF6MHmQgJThESHQQjVKfB9VtkgsoaUeGyUN/R7'

null

'b6FqwBXGUT9rmO6eP3ccqDJKDOd/u5M3/j+PVJZ'