Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Data Type

kneri3
7 - Meteor

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
13 - Pulsar
13 - Pulsar

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
Alteryx
Alteryx

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
Alteryx
Alteryx

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
7 - Meteor

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

 

Labels