Oh no! The Community appears to be haunted! Help us find all the spooky specters here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Alteryx Designer Discussions

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

Dynamically Parse and Normalize data

mercurial_maverick
8 - Asteroid

Hello all,

 

I've an excel file that has Material# and Item Description in column A & B. I need to parse and retrieve refrigerant type and cylinder size from column B. The expected output is show in column C,D, F & G. For row 2, there is no cylinder size in column B and hence this need to be retrieved from column A (30 in BANK30R22W). Column G needs to be numerical and not a string. Please let me know how to achieve this.

 

4 REPLIES 4
clmc9601
12 - Quasar

Hi @mercurial_maverick,

 

Will this work for you? I used a variety of regex expressions to parse the item description column. Alteryx has a lot of great resources on regex if you're interested in learning more!

 

Screen Shot 2021-02-17 at 1.21.04 PM.png 

mercurial_maverick
8 - Asteroid

@clmc9601 Could you please send just the workflow alone and not as a packaged file?

clmc9601
12 - Quasar

Sure, here you go:

mercurial_maverick
8 - Asteroid

@clmc9601 That worked, thank you!

Labels