Alteryx Designer Desktop Discussions

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

Keyword to replace whole words and those does not match the keyword leave blank

XXX_Rosy_XXX
7 - Meteor

 

I need help to find the row with UF, Oth, HF and SF at the beginning and put an a new column AV Fault Type. If it beginning letter doesnt start with these keyword, AV Fault Type column will be blank. 

 

If UF - User Familiarization

Oth - Others

HF - Hardware Fault

SF - Software Failure 

 

Resolution remarks
 
issue user not familiar two  laptop wirelessly conaction now show hem it’s work well
Oth, Electric power trip, reset and work well.
UF, user not familiar, teach about wirelessly connection and Shareing screen features.
issue user laptop hdmi plug in  wirelessly connection now reseat and wirelessly conaction now work well
 
issue group E synap hang reboot manually it’s work
HF, Control panel hang, off/on power work well
issue USB cable fluty change new cable its work well
UF, Hdmi cable not plug to laptop
issue not visuallizar issue controller chelact hdmi ned two press two-time vga /dog com also sam now it’s work

 

Output

 

Resolution remarksAV Fault Type
  
issue user not familiar two  laptop wirelessly conaction now show hem it’s work well 
Oth, Electric power trip, reset and work well.Others
UF, user not familiar, teach about wirelessly connection and Shareing screen features.User Familiarization
issue user laptop hdmi plug in  wirelessly connection now reseat and wirelessly conaction now work well 
  
issue group E synap hang reboot manually it’s work 
HF, Control panel hang, off/on power work wellHardware Fault
issue USB cable fluty change new cable its work well 
UF, Hdmi cable not plug to laptopUser Familiarization
issue not visuallizar issue controller chelact hdmi ned two press two-time vga /dog com also sam now it’s work 
1 REPLY 1
BS_THE_ANALYST
14 - Magnetar

@XXX_Rosy_XXX you can use the formula: StartsWith() in Alteryx.

 

You need to clear up your logic though Rosy. Your "Output" doesn't match the rules you've given.

 

Here's an example of how to use the StartsWith formula:

1.png

 

All the best,

BS

Labels