We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

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

Spliting rows with variable values

Luk88kk
8 - Asteroid

Hello everyone,
once again I am stuck and need your help. This is probably related to RegEX with which I am very beginner.
Namely, I have the following table. It contains:
-product names (alphabet - except for one example which has M18 in its name)
-punctuation
-product numbers (always 10 alpha-numeric digits)
-quantity
My task is to have product names and product numbers on separate rows. All punctuation and information about quantity should be removed. (marked in red).

 

This is the original table:

 

Luk88kk_1-1643205134991.png

 

 

This is what the table should look like:

 

Luk88kk_2-1643205183760.png

 

I am asking for your help.

3 REPLIES 3
Thableaus
17 - Castor
17 - Castor

Hi @Luk88kk 

 

Honestly there are too many variations to consider in a REGEX. Is there a better pattern for product name (specifically) other than just having letters and a possible "M18"? 

 

If you could provide more patterns the expression can be more consistent to your use case. REGEX is all about finding patterns and standards.

 

Cheers,

Qiu
19 - Altair
19 - Altair

@Luk88kk 
We do need a big dataset to be more accurate.
based on current data, I havve only worked out the Field2.
For field 1, I am afraid we need an iterave macro to do it. Give me a bit of time.

0127-Luk88kk.PNG

Luk88kk
8 - Asteroid

Awesome! 

I would never have come to that.

Thank you very much.

Labels