Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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