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.
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.
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!
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.
I'm just trying to create a new column that has the data types of the column in front of it