Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Wildcard XLSX input tool giving the header names in ROW 1

Idyllic_Data_Geek
8 - Asteroid

I'm using wildcard xlsx input tool to read multiple tabs from an excel file. The issue that I'm facing is that the output from macro has incorrect header names....F1,F2,F3 and so on. The header values are displayed in row 1. When I uncheck the option of row containing headers then it does not help. Any idea on how I can solve for this?

 

 

 

 

4 REPLIES 4
Felipe_Ribeir0
16 - Nebula

Hi @Idyllic_Data_Geek ,

 

The First Row Contains Data shold work. Please note that you need to save the macro (if you are talking about the wildcard xlsx macro), so the changes will be reflected on your main workflow.

 

uncheck

Felipe_Ribeir0_0-1664383089295.png

 

check

Felipe_Ribeir0_1-1664383104238.png

 

Could you provide the workflow with some dummy data?

Idyllic_Data_Geek
8 - Asteroid

Idyllic_Data_Geek_0-1664383306323.png

This is what I have

Felipe_Ribeir0
16 - Nebula

Hi @Idyllic_Data_Geek 

 

I downloaded the tool and tested it here, for me the header is working fine. Take a look at the attached workflow.

 

Felipe_Ribeir0_0-1664384651006.png

 

Felipe_Ribeir0_1-1664384687031.png

 

Felipe_Ribeir0
16 - Nebula

Hi @Idyllic_Data_Geek 

 

It worked?  

Labels