Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

int and str in one column

7 - Meteor

Hello everybody, 


does somebody know how i can detect or select only str/int in one column. 

i have numbers and words in there....


would be really happy if someone could help me with this 🙂


LG Timo 

11 - Bolide

you will need the regex tool



you will need to learn how to set up the pattern to match what your data looks like and what you're trying to do. you can use this tool to pick only text characters or only numbers or a lot of other patterns

17 - Castor
17 - Castor

Hi @Timo97,


One column can have only one data type. Maybe you can create two new columns. Use a select tool in order to change the data type to the number and if some of them become empty when you change the data type you should create a new column with text but only for those positions that are empty. 


I hope that makes sense. 



22 - Nova
22 - Nova

Hi @Timo97 


If you want to split number and strings. Here is how you can do it.




Hope this helps : )


8 - Asteroid

Hi @Timo97 ,


Try isInteger() function. It will split the Integers and Strings seperately. Hope this helps



22 - Nova
22 - Nova

Hi @Pravallika20 


Interesting IsInteger() works but IsNumber() doesn't work. Any thoughts why 🤔

8 - Asteroid

Hi @atcodedog05 ,


isInteger() function checks if the value can be converted to Integer. Isnumber() function directly checks if the value is number. For further clarifications, please refer to https://help.alteryx.com/20213/designer/test-functions. 


18 - Pollux
18 - Pollux



Isinteger() tries to convert the number.  IsNumber() checks the field type.


Btw.  The regex examples above need to be modified to check for an optional "-" in the case of negative integers.