topic Re: Special characters problem from googlesheet data in QlikView

Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 09:22:18 GMT

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

Re: Special characters problem from googlesheet data

mayankraoka — Wed, 13 Jun 2018 09:38:20 GMT

Hi,

Try this:

LOAD

Text(YouField) as YourField,

...

FROM ...;

Which version of qliksense you are using?

Regards,

Mayank

Re: Special characters problem from googlesheet data

Chanty4u — Wed, 13 Jun 2018 09:43:06 GMT

if you know characters

you can use

purgechar(field,'~!@#$%^&*()_+') as Yourfield

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 09:48:16 GMT

Hi,

Text function is not working.

Version - 12.5.2

Re: Special characters problem from googlesheet data

mayankraoka — Wed, 13 Jun 2018 10:05:43 GMT

so if you know the characters you can try what Chanty said Keepchar fucntion like this

keepchar(field,'~!@#$%^&*()_+') as Yourfield

Regards,

Mayank

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 10:09:26 GMT

How to put ö char into the list. Any idea?

Regards,

Lakshminarayana

Re: Special characters problem from googlesheet data

mayankraoka — Wed, 13 Jun 2018 10:49:14 GMT

you can take from character map .Attached screenshot.

Regards,

mayank !

Re: Special characters problem from googlesheet data

hic — Wed, 13 Jun 2018 11:18:08 GMT

Most likely, you need to configure the connector to use Unicode / UTF8 instead of codepage 1252.

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 11:22:23 GMT

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]

Re: Special characters problem from googlesheet data

mayankraoka — Wed, 13 Jun 2018 11:32:15 GMT

Ideally you should not get blank,

try this,

keepChar([Global Customer Name],'ö') as [Global_Customer_Names]

Regards,

Mayank

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 12:06:13 GMT

No Mayank, getting the same result.

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 12:09:05 GMT

Hi Henric,

How to configure the connector? Do you have the link to download?

Regards,

Lakshminarayana

Re: Special characters problem from googlesheet data

hic — Wed, 13 Jun 2018 12:52:01 GMT

I don't know which connector you use, so it is impossible for me to tell...

If you use a connector so that the script looks something like

CONNECT TO GoogleData .<connectionString> ;

SQL SELECT ... FROM ... ;

then you need to change your connection string or your ODBC settings. How you should do that, I don't know - it depends on which connector you use.

If, instead, your script looks like

LOAD ... FROM http://someurl.com/table.htm (html, codepage is 1252, embedded labels, table is @1);

then you need to change this to

LOAD ... FROM http://someurl.com/table.htm (html, utf8, embedded labels, table is @1);

HIC

Re: Special characters problem from googlesheet data

bobbyn4u — Wed, 13 Jun 2018 16:21:25 GMT

Hi Henric,

I am using the QLIK Google Drive & Spreadsheets Connector. Kindly let me know the process how to proceed further.

Regards,

Lakshminarayana Palla

Re: Special characters problem from googlesheet data

Darren_Ball — Wed, 13 Jun 2018 23:05:04 GMT

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!

Re: Special characters problem from googlesheet data

bobbyn4u — Thu, 14 Jun 2018 07:05:11 GMT

Hi,

Thank you so much, Darren! Could you please share the download link for the "Patch for Qlik Web connectors".

Thanks in advance.

Regards,

Lakshminarayana

Re: Special characters problem from googlesheet data

bobbyn4u — Mon, 18 Jun 2018 10:14:49 GMT

Thank you, Darren, its working with the latest version (November 2017, Patch 2).