Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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