Alteryx can't read in address
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there,
I used a macro to read multiple files into alteryx. In some files, alteryx reads in every column correctly. In other files, alteryx can read every column except the address column. It just shows column title but no content in the columns.
The fact that this macro works for some files makes me think coding works. I am puzzled what can cause other files not to be read in correctly. Could the reason be a different language? English address reads in fine, German addresses sometimes have issues being read correctly. Have you seen language/formatting issues in excel that would cause the entire address column not be read?
Alteryx flow looks like this
Directory -> Formula([FullPath]+"|||'Reporting Characteristics$'") -> Macro
Thanks,
Yiling
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It could be due to the Code Page. But it usually returns giberrish if it can't read the Code Page. For example, Chinese characters get swapped with icons in ISO 8859-1 Latin 1, whereas it works fine if we use Unicode UTF-16.
So if it is a Code Page issue, can you check those German addresses for ä, ö, ü and ß? Do they return as gibberish or completely empty?
EDIT: Maybe you can provide some pics as well to better visualize the problem
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/