Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎09-21-2022 08:56 AM

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

 

 

Reply
0 Likes
2 REPLIES 2
rickey0830
8 - Asteroid
‎09-21-2022 09:05 AM

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

Reply
0 Likes
npariso
10 - Fireball
‎09-21-2022 09:12 AM

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

Reply
0 Likes
go to user group event calendar
Labels