Hi there,
I have a dataset which looks like this:
Description | Quantity |
Lounge (Qty8) | |
Picture Qty11 | |
Fridge Qty 6 | |
Mugs (Qty100) | |
Room 205 | |
Room 206 | |
Hallway 0-12m |
I want Alteryx to extract unit quantities from the description column (but not other numbers) such that my final dataset looks like this:
Description | Quantity |
Lounge (Qty8) | 8 |
Picture Qty11 | 11 |
Fridge Qty 6 | 6 |
Mugs (Qty100) | 100 |
Room 205 | |
Room 206 | |
Hallway 0-12m |
Could someone please help me set this up?
Thanks in advance!
Solved! Go to Solution.
Thanks, @ShankerV! Always appreciate your help.