Data Type

[kneri3]

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?

[T_Willins]

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.

[echuong1 · Accepted solution]

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 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Field-Summary/ta-p/104...

Let me know if that helps!

[BrianR]

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.

[kneri3]

I'm just trying to create a new column that has the data types of the column in front of it