Hello everyone,
I have a problem decrypting a table in Qlik Sense.
I've been reading and Qlik View can be done but not in Sense.
This code works in View but not in Sense:
//Encryption
Cards_Encrytion:
LOAD CARDNUMBER as Card_Number_ClearText,
aesEncrypt(text(CARDNUMBER), '$(pwd)') as Card_Number_Encrypted,
TXNCODE,
POSTDATE
FROM
SourceTable.xls
(biff, embedded labels, table is Sheet1$);
STORE Cards_Encrytion into Cards_Encrypted.qvd(qvd);
//Decryption
NoConcatenate
Cards_Decrytion:
LOAD Card_Number_ClearText,
aesDecrypt(text(Card_Number_Encrypted), '$(pwd)') as Card_Number_Decrypted
FROM Cards_Encrypted.qvd(qvd);
STORE Cards_Decrytion into Cards_Decrypted.qvd(qvd);
The part in red is the one that fails in Sense.
I have developped a encryption program in Java with AES and I need to decrypt it with Qlik SENSE.
Is there any solution to decrypt tables in Sense?