Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
Can you upload an sample excel file?
-Rob
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;
Hi Bala,
It worked! Many, many thanks for your help!
Thanks,
Neil
Hi Bala/Rob, Bala's suggestion worked. Many thanks for responding it is much appreciated. Thanks, Neil
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
Sorted- thank you
Replace(Replace(,'_x0020_',' '),'_x002F_',' ') as ,
Thanks,
Neil
Thanks Neil, I'm very glad that, solution help you to resolve the issue.
Please mark it as Answered & Close this thread.