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!

[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 : )

[Akash__on]

yes that's also a fast alternative. 😅

[binuacs]

@Rahul_Analyst Another option

[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!  

[Rahul_Analyst]

Hi @atcodedog05, 

Thanks for responding!

Same as I responded to @Akash__on, If I skip fist sub headers, then how can I get it in output files ?

[Rahul_Analyst]

@binuacs ,

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. 

[Akash__on]

@Rahul_Analyst I understood your problem, on Alteryx its generally one data type per field. When we union two different data type it generally changes it to VString or string as it helps Alteryx to maintain the uniformity in the metadata . So output will be in String format.

rest I will check more test cases.

Best regards

Akash

[Rahul_Analyst]

@Akash__on ,

I would be really grateful I get the solution for it. Actually, from last 3 days, I have been thinking and trying to resolve it. But unable to do. 

Here, one more issue, I have posted on community. However, unfortunately, nobody has replied over it. Please see if you can provide a solution for mentioned below problem.

https://community.alteryx.com/t5/Alteryx-Analytics-Hub-Discussions/Deleting-very-last-column-of-exce...

Thanks a lot!