Alteryx Designer Desktop Discussions

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

Alteryx can't read in address

yilingchen02
8 - Asteroid

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

1 REPLY 1
caltang
17 - Castor
17 - Castor

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

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels
Top Solution Authors