Dynamically Parse and Normalize data

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.

Example.xlsx

Datasets

Output

Parse

Dynamic Processing

Preparation

Optimization

Data Investigation

Accepted answers

clmc9601

Sure, here you go:

regex_mercurial_maverick.yxmd

All comments

clmc9601

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

regex_mercurial_maverick.yxzp

mercurial_maverick

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703