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?
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
check
Could you provide the workflow with some dummy data?
This is what I have
I downloaded the tool and tested it here, for me the header is working fine. Take a look at the attached workflow.