We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need to transform base string with multiple suffix's separated by a delimiter

BrooksGrebin
5 - Atom

Hello,

 

The problem I have is that we have unique strings that represent a product of ours.  For each line of products, we have different colors that change the 'suffix' of the unique string.  For example, Product A's base string is AA123, and depending on the color, it will have a different suffix such as a blue Product A is AA123XY and a red Product A is AA123ZT.

 

The issue is all colors of the product are mashed at the end of the base part, separated by a backslash.  My goal is to have a unique string for each of the base part - color combinations so we can easily join these unique strings to other datasets within our company.

 

I've gotten as far as parsing by the delimiter(backslash) but I'm hoping someone can help me develop a workflow on sticking the suffix's back on to the base string.  The trickly part is that not every suffix is the same length of character.  Example of before/after state is below and thank you for your help!

BrooksGrebin_0-1685654250343.png

 

3 REPLIES 3
smoosh
8 - Asteroid

Try the attached workflow. You were just about there. 

 

Best of luck. 

Qiu
21 - Polaris
21 - Polaris

@BrooksGrebin 
Is you " unique strings" has a fixed length?

acarter881
12 - Quasar

Hello, @BrooksGrebin.

 

I believe the attached workflow solves this problem. There will need to be edits if the base string is not 5 characters. Perhaps you can review and let us know? Hope this helps.

 

acarter881_0-1685665760958.png

 

Labels
Top Solution Authors