Alteryx Designer Desktop Discussions

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

Alteryx reading special character from DBF table

smallpotato
7 - Meteor

Hi all,

 

I have a dbf table containing special characters like "À" and has to be read into an Alteryx workflow. However, the Alteryx converted it to "?" even Im using "wstring" as my datatype. I have checked the datatype in my dbf table of this field is "character". May I know how may i fix it? sorry that im not able to provide with you my sample data.

 

I am using the directory tool and the input tool embed in a batch macro to input my dbf table.

1 REPLY 1
cjaneczko
13 - Pulsar

In your input tool check the box that says "Force SQL WChar Support"

 

image.png

Labels