Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is quite interesting and wanted to see if anyone can confirm this works in Sense
https://community.qlik.com/message/304652
or
Encryption in QlikView — Medium
Thanks!
The AES functions are there, but there are some hashing functions:
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash128.htm
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash160.htm
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash256.htm
So to use the Hash256 function here is a sample script:
TestData:
LOAD * INLINE [
Person,FICO
Bob, 750
Alice, 700
John, 750
James, 600 ];
Hashing:
LOAD
//Person as PersonHash,
hash256([FICO]) as [FICOHash]
Resident TestData;
The AES functions are there, but there are some hashing functions:
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash128.htm
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash160.htm
https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/StringFunctions/Hash256.htm
So to use the Hash256 function here is a sample script:
TestData:
LOAD * INLINE [
Person,FICO
Bob, 750
Alice, 700
John, 750
James, 600 ];
Hashing:
LOAD
//Person as PersonHash,
hash256([FICO]) as [FICOHash]
Resident TestData;
Thank you Levi!