Hi
I have a remarks columns which has some keywords. From the remark column, i wanted to find the keywords(below) and add a new AV Faulty Type column with the full keyword name. Like the example below. what tool can I use in Alteryx
Keywords
UF - User Familiarization
SF - Software Failure
Oth - Others
HF - Hardware Fault
Remarks Columns AV Fault Type Column
UF issue users not familiar Wellesley connection now connection it’s done Software Failure
HF, Hdmi transmitter signal week, replaced new transmitter. Now work well User Familiarization
Oth, Power socket loose connection, Now fixed back work well Hardware Fault
SF issue main Panel synapse hang reboot manually it’s work Others
New Column
Solved! Go to Solution.
Step 1: Using Data Cleansing tool to remove the trail white spaces
Step 2:
Step 3:
Step 4:
Many thanks
Shanker V