Change data type

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!

Sample.xlsx

Preparation

Accepted answers

All comments

Akash__on

1) Use Sample tool to remove 1st two rows.

2) use Select tool to change the data type.

(this is a meta data view)

atcodedog05

Hi @Rahul_Analyst

You can just read the data from 3rd line and change datatype like below

Hope this helps : )

sub header.yxmd

binu_acs

@Rahul_Analyst Another option

ChangeDataType.yxmd

Rahul_Analyst

Hi @Akash__on,

Thanks a lot for responding!

However, it did not resolve my issue.

Applying your suggestion, we could change the data type by skipping first 2 rows, but after that when I union which I skipped then the data type again comes in string. As I want my output with sub-headers, so I need to add it.

Please see my attached workflow.

Thanks again!

Change data type.yxmd

Rahul_Analyst

@binu_acs ,

Please try for a solution where I can get my sub headers and data type can also be changed.

I am sure guys, with your help, we can do this.

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.

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.

Workflow Range.yxzp

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703