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

[Anonymous]

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

[rwunderlich]

Can you upload an sample excel file?

-Rob

[balabhaskarqlik · Accepted solution]

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;

[Anonymous]

Hi Bala,

It worked! Many, many thanks for your help!

Thanks,

Neil

[Anonymous]

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

[Anonymous]

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

[Anonymous]

Sorted- thank you

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

Thanks,

Neil

[balabhaskarqlik]

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

Please mark it as Answered & Close this thread.