topic How do you change the data decoding/encoding in Qlik Sense? in Connectivity & Data Prep

How do you change the data decoding/encoding in Qlik Sense?

Anonymous — Mon, 23 Jul 2018 16:37:26 GMT

Hi,

Does anyone know how to change the encoding/decoding in Qlik Sense? I ask because I have an application which reads data from an Excel spread sheet in which the data looks fine but in Qlik Sense SPACES between words come out as _x0030_ (see attached picture). So for example Joe Bloggs would come out as Joe_x0020_Bloggs. To fix the problem I have to copy and paste special in excel as values then resave which sorts it out. This is fine for a one off but I have multiple reports on a daily basis to do this to.

For extra info I am exporting the data from SAS into the excel file and have tried every encoding SAS has to offer but the all come out the same.

Many thanks for your help,

Neil

Re: How do you change the data decoding/encoding in Qlik Sense?

rwunderlich — Mon, 23 Jul 2018 18:57:21 GMT

Can you upload an sample excel file?

-Rob

Re: How do you change the data decoding/encoding in Qlik Sense?

BalaBhaskar_Qlik — Tue, 24 Jul 2018 06:32:18 GMT

May be after data load, you can replace that unwanted value with space as below:

ABC:

Load

Name

From abc.xlsx;

Noconcatenate

Temp:

Load

Replace(Name,'_x0020_',' ') as Name

Resident ABC;

Drop table ABC;

Re: How do you change the data decoding/encoding in Qlik Sense?

Anonymous — Tue, 24 Jul 2018 07:38:05 GMT

Hi Bala,

It worked! Many, many thanks for your help!

Thanks,

Neil

Re: How do you change the data decoding/encoding in Qlik Sense?

Anonymous — Tue, 24 Jul 2018 12:12:50 GMT

Hi Bala/Rob, Bala's suggestion worked. Many thanks for responding it is much appreciated. Thanks, Neil

Re: How do you change the data decoding/encoding in Qlik Sense?

Anonymous — Tue, 24 Jul 2018 13:05:07 GMT

Hi Bala,

Can the replace function work for multiple replacements in one statement? For example

Replace(Name,'_x0020_',' ') or Replace(Name,'_x002F_',' ') as Name

Replace(,'_x002F_' or '_x0020_',' ') as ,

I know the above do not work but unsure of Syntax for multiple replaces of the same variable.

Thanks,

Neil

Re: How do you change the data decoding/encoding in Qlik Sense?

Anonymous — Tue, 24 Jul 2018 13:22:31 GMT

Sorted- thank you

Replace(Replace(,'_x0020_',' '),'_x002F_',' ') as ,

Thanks,

Neil

Re: How do you change the data decoding/encoding in Qlik Sense?

BalaBhaskar_Qlik — Tue, 24 Jul 2018 16:08:13 GMT

Thanks Neil, I'm very glad that, solution help you to resolve the issue.

Please mark it as Answered & Close this thread.