Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Have the need to decode a Base64 string in Sense OnPremise, how can I do that?
Implemented my own Base64 decoding in Qlik Sense.
It is slow but it works for my case, got the data I needed decoded.
Refer this article
Thanks but I'm not loading an image to show in Sense, I'm loading data encoded in Base64 and need to decode that data!
refer page 6 of the below document attached in the article
@vinieme12 as I said above I'm NOT loading an image!
Implemented my own Base64 decoding in Qlik Sense.
It is slow but it works for my case, got the data I needed decoded.
Hi @anderseriksson,
Could you kindly share the solution you implemented for this problem?
Thanks in advance.
Regards,
Huberto Pereira Haideman
@Huberto just noticed your question and don't know if it is still valid (not had time for the forum for some while).
My solution was using Qlik Script to translate Base64 text but very slow and with increasing data it was no longer valid. Changed to a different solution involving things available in Windows.
Not the prettiest solution but it works for my case.
1) save the Base64 string to a text file: path\Base64.utf
2) that file is UTF encoded by Qlik but I need it to be ASCII for the Windows decoding!
Thus I run the Powershell command: Get-Content path\Base64.utf | Set-Content path\Base64.txt -Encoding Ascii
3) to decode the Base64 Ascii file i run Windows command;
certutil -decode -f path\Base64.txt path\Decoded.csv
4) now I can use Decoded.csv in Qlik Sense like any other csv-file
Wanted to run these commands from inside Qlik Script with exec command but that would not work.
Instead I configured it as a Scheduled Windows Task to coincide with my Qlik Tasks.
Doing this at night I have no timing issues with the tasks as I can leave margins between.
Hope this helps.
Maybe this could help with the decoding:
Thanks for taking the time to reply to my question, @anderseriksson.
Regards,
Huberto Pereira Haideman