Change data type
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
1) Use Sample tool to remove 1st two rows.
2) use Select tool to change the data type.
(this is a meta data view)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can just read the data from 3rd line and change datatype like below
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yes that's also a fast alternative. 😅
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Thanks a lot!
