Alteryx can't read in address

yilingchen02

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

caltang

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