In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Filter and map column based on last character

kauser
8 - Asteroid

Hello, 

can you please let me know how can i mapping a column based on last character from previous column. 

 

Input 

NAME
DFHR1TA
DNCH1TB
RTYD1FG
WERY1OA
OUTY1ET

If last character from input column is between A-B then they should mapped into YES and anything else should be mapped into NO

 

Output 

 

NAMETYPE
DFHR1TAYES
DNCH1TBYES
RTYD1FGNO
WERY1OAYES
OUTY1ETNO
1 REPLY 1
griffinwelsh
12 - Quasar

You can use a formula tool with if,right, and in functions. A screenshot of the required config is attached

 

 

2004.png

Labels
Top Solution Authors