Alteryx forcing entire row data type which removes some of the headers in the XLS file

[bjschwartz3]

I'm reading in a XLS file which has the header on row 11. The problem is some of the fields are being read in as a DateTime, Double, or Int data type which then causes the header row to be NULL. How do I read in the entire file without losing some of the headers?

[Ben_H]

Hi @bjschwartz3 

Have you tried setting the input to start reading data at row 11 as below?

Regards,

Ben

[bjschwartz3]

@Ben_H I don't think you have that option for XLS files.

[messi007]

Dear @bjschwartz3,

Could you share a simple data ?

Regards

[bjschwartz3]

Raw data:

Configured input tool:

 DataTypes:

 

[Ben_H]

Hi @bjschwartz3 

I didn't know it didn't work for xls! Well i've learned something new there.

The alternative is to set the input range when you select the sheet. In your case it would start with A11 and then to whatever the extent of your data is.

Regards,

Ben