Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx doesn't recognize certain characters?

Pav
7 - Meteor

I converted word document into txt file using this method 

http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Can-Alteryx-Parse-A-Word-Doc-Or-PDF/ta-p/1156

 

When the txt file is loaded into alteryx, some of the characters are not being recognized.

E.g. (comma only for separation) 

 

-, ", ..., ' 

 

Those appears in Alteryx as 'â'€. I can easily replace that but the issue I have is that there is no way of knowing which is which as all of the above characters are replaced by –.

I import the txt file as CSV with \0 as delimiter.

 

Example

In txt file - “   Account Type – PAT status, Channel & HQ area:

In alteryx -   Account Type – PAT status, Channel & HQ area:

in txt file -   The non-highlighted fields on the form (indicated with ‘click to enter text)

in alteryx -  The non-highlighted fields on the form (indicated with ‘click to enter text)

in txt file  -  Defend – Key Actions

in alteryx    Defend – Key Actions

and so on.

 

Ideally, I would like the txt file to be loaded in a way that all of those characters are being recognized. 

 

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
I have some help for you. Look at your input tool and scroll down in the configuration panel. Option #11 is code page. Change latin ... to whichever is the correct character set for your data. Thanks, Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Pav
7 - Meteor

Works perfectly, thank you!

Labels