topic Re: Use base64_decode PHP function in Qlikview in QlikView

Use base64_decode PHP function in Qlikview

qlikhalmar — Fri, 14 Apr 2017 11:47:37 GMT

Hello all,

I need to decode a field in mij databasetable. It is filled with a value like:

YTo1OntzOjU6Iml0ZW1zIjthOjE6e2k6MDthOjE3OntzOjY6Iml0ZW1JZCI7czozOiI0NjkiO3M6NToiY291bnQiO2k6MTtzOjc6Im9wdGlvbnMiO2E6MDp7fXM6NDoiaGFzaCI7czoxNToibHJzcHlvNDl6WlZEVFVhIjtzOjk6Im9wbWVya2luZyI7czoxMDI6IlppZSBlbWFpbCB2YW4gamVudGVkZWpvbmdAZ21haWwuY29tIHZlcnN0dXVyZCBvcCAxMiBhcHJpbC4gbWVwdGFhcnQgYmlqcGFzc2VuZCBiaWogZ2Vib29ydGVrYWFydHRhYXJ0LiI7czo4OiJsZWVmdGlqZCI7YjowO3M6NDoiZmlsZSI7YjowO3M6NDoidHlwZSI7czo1OiJ0YWFydCI7czo0OiJuYW1lIjtzOjIwOiJNZXAtIGVuIFBsZXQgVGFhcnRqZSI7czoxMToicHJvZHVjdENvZGUiO3M6NzoiTWVwLTAwMiI7czo3OiJmaWxlVXJsIjtiOjA7czo1OiJwcmljZSI7czo1OiIxMi45NSI7czo2OiJ0YXhMb3ciO3M6NDoiMC43MyI7czo3OiJ0YXhIaWdoIjtzOjQ6IjAuMDAiO3M6MTA6InRvdGFsUHJpY2UiO3M6NToiMTIuOTUiO3M6MTE6InRvdGFsVGF4TG93IjtzOjQ6IjAuNzMiO3M6MTI6InRvdGFsVGF4SGlnaCI7czo0OiIwLjAwIjt9fXM6MTA6InRvdGFsUHJpY2UiO3M6NToiMTIuOTUiO3M6NDoidHlwZSI7czo1OiJ0YWFydCI7czoxMToidG90YWxUYXhMb3ciO3M6NDoiMC43MyI7czoxMjoidG90YWxUYXhIaWdoIjtzOjQ6IjAuMDAiO30=

In PHP you can use the function unserialize(base64_decode("<tekst>")).

Can anyone help me to do this in QlikView/Qlik Sense?

Thanks!

Halmar

Re: Use base64_decode PHP function in Qlikview

Anil_Babu_Samineni — Fri, 14 Apr 2017 13:11:45 GMT

This binary size is long. This will run as False. Or would you describe more with output

Re: Use base64_decode PHP function in Qlikview

qlikhalmar — Fri, 14 Apr 2017 13:26:01 GMT

The first step is to decode the string.

I found out that you can do that with SQL:

FROM_BASE64(<field>) AS Field

But, the array that you get is a different story....

Re: Use base64_decode PHP function in Qlikview

Peter_Cammaert — Fri, 14 Apr 2017 14:07:49 GMT

You cannot use PHP script code in a QlikView document without spending a lot of time and energy trying to glue the pieces together. But you can decode a Base64 encoded field value using a comparable VBScript macro that is called in your LOAD script.

See the first function (appropriately called "Base64Decode") in Re: How to generate xuser & xpassword in txt file

Best,

Peter