Skip to main content

Celonis Product Documentation

STRINGHASH
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'