community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Cyrillic characters encoding in input tool

Atom

Hi all,

 

I have been struggling for few months now to solve cyrillic characters import issues in Alteryx. Data is pulled from a DB2 database, through an input data tool and the cyrillic characters translate into some nice looking squares.

 

When same data is imported through EXCEL, saved in xls and imported to Alteryx, everything goes fine. This means that Alteryx can support those characters (proper code page I believe).

 

Knowing that Alteryx has other data types than V_String, how do I coerce Alteryx to import the data at first touch (in the input data tool) as something else than can work ?

 

PS: I have tried VW_String by modifying from the xml directly this section:

<MetaInfo connection="Output">
   <RecordInfo>
     <Field name ="myfield" size="1000" source="File: odbc:DSN=blablabla" type = "VW_String">

 

...but without much success

 

Regards,

Alteryx Certified Partner
Alteryx Certified Partner
Your ODBC connection needs to be defined with the proper translation of the Cyrillic code page. If you google that topic you'll see some help for getting the data out of db2 and Alteryx will display something other than boxes.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom
Odbc connector works well as I can pull the same data to excel without any encoding issue.

Envoyé de mon iPhone

Ce message électronique et tous les fichiers attachés qu'il contient sont confidentiels et destinés exclusivement à l'usage de la personne à laquelle ils sont adressés. Si vous avez reçu ce message par erreur, merci de le retourner à son émetteur. Les idées et opinions présentées dans ce message sont celles de son auteur, et ne représentent pas nécessairement celles de DANONE ou d'une quelconque de ses filiales. La publication, l'usage, la distribution, l'impression ou la copie non autorisée de ce message et des attachements qu'il contient sont strictement interdits.

This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of DANONE or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Alteryx Certified Partner
Alteryx Certified Partner
I'm on my iPhone too. I do wonder if there is a code page option or an advanced configuration option

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Atom

I was also wondering the same....

Labels