Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Input choice

Aleksandar1
7 - Meteor

In my input file,some rows have dropdown list wtth 1,2 and 3 choices,i need solution to remove text from them throught workflow.

Looks like this 

1-some random text

2-other text

3- some other text 

User will choose some from that and throught workflow i need to get just 1,2 or 3 in output

5 REPLIES 5
caltang
17 - Castor
17 - Castor

Not very sure I understand you right... could you provide some sample data and what your expected output would look like?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Aleksandar1
7 - Meteor

My input has dropdown list which contains : 1-some text, 2-some text,3-some text,and user will choose what he needs,and then that input will go in workflow,for example it will be 2-some text, i need solution that will remove this -some text so in output will only 2 will be shown

caltang
17 - Castor
17 - Castor

Could you kindly provide some data to work with...?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
cjaneczko
13 - Pulsar

Does this work?

 

 

Left([Choice], 1)

 

 

cjaneczko_0-1686663238581.png

cjaneczko_1-1686663250290.png

cjaneczko_0-1686663359695.png

 

 

 

steven_king
6 - Meteoroid

Hi @Aleksandar1 you can use this formula in a formula tool to only get the first character in a field:
LEFT([Field],1)

 

image.png

Labels