We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Input Excel File Inconsistencies - Column Names

npariso
10 - Fireball

I have a workflow created which allows for a dynamic reading of excel sheets within a single file.

 

Why is Alteryx adding F to some columns but not others. I am starting my import on line 1 and I have "First Row Contains Data" unchecked. Both input configurations are exactly the same and there is no processing being done to the data before appearing.

 

Is it possible that Alteryx is adding F to the hidden or grouped rows only?

 

Thanks for any insight on this!

 

npariso_0-1663775737858.png

npariso_1-1663775747124.png

 

 

2 REPLIES 2
rickey0830
8 - Asteroid

Do your some of your input files not have the same number of columns and/or not 100% uniform naming schema on the columns?

npariso
10 - Fireball

Column count and schema shouldn't matter in this case as it is not a batch macro.

Labels
Top Solution Authors