Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a data in google sheets and it is connected to Qliksense using connectors. There are few special characters in the data like Börse and getting the data in Qliksense as B~A?se . Kindly help me out how to handle this kind of data loading from google sheets.
output should be:
Börse
Hi,
I'm not sure which version of the Qlik Web Connectors you are using, but could you please try the latest version (November 2017, Patch 2) because an issue with character encoding for Google Spreadsheets was fixed in a patch earlier this year (Patch for Qlik Web Connectors November 2017 Release Available).
If you still have issues with the latest version, please let me know.
Thanks!
Hi,
Try this:
LOAD
Text(YouField) as YourField,
...
FROM ...;
Which version of qliksense you are using?
Regards,
Mayank
if you know characters
you can use
purgechar(field,'~!@#$%^&*()_+') as Yourfield
Hi,
Text function is not working.
Version - 12.5.2
so if you know the characters you can try what Chanty said Keepchar fucntion like this
keepchar(field,'~!@#$%^&*()_+') as Yourfield
Regards,
Mayank
How to put ö char into the list. Any idea?
Regards,
Lakshminarayana
you can take from character map .Attached screenshot.
Regards,
mayank !
Most likely, you need to configure the connector to use Unicode / UTF8 instead of codepage 1252.
Thank you, Mayank. I tried the keep char function, I am getting the blank data in that field. Kindly check the below function and let me know the solution.
keepChar([Global Customer Name], 'Ö') as [Global_Customer_Names]
Ideally you should not get blank,
try this,
keepChar([Global Customer Name],'ö') as [Global_Customer_Names]
Regards,
Mayank