column header formatting issue

[nicnac_1]

I have an Excel file with a good amount of data.  When I add the data to the input tool it only reads the first few column headers then makes the other column headers F5, F6, etc.  Below are made up headers of how it should look from excel vs. what appears in Alteryx. I've used the select tool and it is showing that the Type and Size are the same. Can someone help or send link for similar issue from the Alteryx Community?  I am using Alteryx Designer x64 version: 2024.1.1.178.

Expected Column Header:

Bird

Cat

Dog

House

Room

Car

How Column Header appear in Alteryx:

Bird

Cat

Dog

House

F5

F6

[Yoshiro_Fujimori]

@nicnac_1 ,

Could you give us the first few rows of your data?

I guess the column 5 and 6 in the first row contains null data

and the original excel header uses two rows combined like below;

Bird	Cat	Dog	House
				Room	Car
1	2	3	4	5	6