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
I want to add a column that has the data types of another column. Is there a function that allows me to do that or a type of formula to grab it?
Solved! Go to Solution.
- Labels:
- Custom Tools
- Developer Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kneri3
Can you provide a sample of what you are trying to do? Generally a field only has one data type associated with it. If you need to know if a field is numeric or string, the Field Summary tool can provide this information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I believe the functionality you're looking for can be achieved using the Field Info and/or Field Summary tools.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Field-Info/ta-p/60723
Let me know if that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This article might be a match for what you're looking for - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-Change-A-Field-Type/td-p/3...
It involves a few tools to get the desired functionality, and will be a multi-step process, but should ultimately let you set the field types to that of another field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm just trying to create a new column that has the data types of the column in front of it
