Alteryx Designer Desktop Discussions

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

Multiple Column Transpose with Rename

Wixard
8 - Asteroid

 

Hi all,

 

I would like to convert a table that has this sample structure

 

 
 BlueRedGreenBlue1Red1Green1Blue2Red2Green2
Attribute123102030100200300
Scale456405060400500600

 

into this

 

 ColourCodePriceDimension
AttributeBlue110100
ScaleBlue440400
AttributeRed220200
ScaleRed550500
AttributeGreen330300
ScaleGreen660600

 

The labels "Colour", "Code", "Price" and "Dimensions" are not actually in the first table, so would need to add that in within Alteryx designer.

 

What formula is needed in the RegEx tool to remove the 1 and 2 after the colour names in first table.

 

 

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Wixard 

 

Here's a workflow to solve your problem

 

Thableaus_0-1584801430203.png

 

Let me know if there are any questions.

 

Cheers,

Wixard
8 - Asteroid

 

Had to build on what you sent to do a few more things I needed, but was exactly what I was looking for.

 

Thanks a lot for your help @Thableaus!!!

Labels
Top Solution Authors