We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

V String Analysis

nicktekippe
8 - Asteroid
‎02-13-2024 11:19 AM

I need a way to make my workflow analyze the 4th character of the serial number and if it is a V update my Dept to '542 - IVT', if it is a D update department to '542 - PST', and if the fourth character isn't a V or D leave dept as whatever it was. Sample data below. If I can provide any more details please feel free to ask.

Repair_IVT_PST.png

 

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
binuacs
21 - Polaris
‎02-13-2024 11:34 AM

@nicktekippe image.png

SubSTring_130224.yxmd
Reply
Community Live
Live Cloud Quest Solve
Labels
Top Solution Authors
View All