Alteryx reading special character from DBF table
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
smallpotato
7 - Meteor
04-14-2024
09:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Datasets
- In Database
- Input
1 REPLY 1
cjaneczko
13 - Pulsar
04-15-2024
07:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In your input tool check the box that says "Force SQL WChar Support"
