Change data type

[Rahul_Analyst]

Hi,

I have a data with a header and 2 sub headers. I want to change data type of values below sub-headers (date type and integer16). However, due to having 2 sub headers, I am unable to change the data type. If I am changing then sub headers are getting affected by changing the data type. I have attached a sample data. 

Please provide me your valuable suggestions and solutions.

Thanks a lot!

[gabrielvilella]

If you have two different data types for the same column name, the resulting field type after the union will always be string.

[Rahul_Analyst]

@gabrielvilella 

Is there any way where Alteryx can read the files with more than 1 row as headers ?

Means, we can define, top 2 or 3 rows are headers, so whatever operation we will do in the data, that would be done below specified rows. 

[gabrielvilella]

No, you can only have one header row. 

[Rahul_Analyst]

@gabrielvilella ,

I also think so now, it is not possible in Alteryx.

[Emil_Kos]

Hi @Rahul_Analyst,

Not sure if I understand your question correctly but if you have a static header you can trick Alteryx and save the data only in a certain range. Thanks to that you will be able to keep the header and change the data type.