Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors