Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

All data in one column, how to create more organized data

6 - Meteoroid

I have a data formatted like Table 1 this but I want to format it like Table 2. Can anyone suggest a dynamic way to do this? 

 

Table 1:

Customer A
50
100
150
Customer B
60
110
160
Customer C
80
120
180

 

 

Table 2:

Customer A50
Customer A100
Customer A150
Customer B60
Customer B110
Customer B160
Customer C80
Customer C120
Customer C180
Highlighted
Alteryx Certified Partner

Hi @abell_dt,

 

You could parse the table using Regex:

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

Highlighted
Alteryx
Alteryx

Hi @abell_dt,

 

My solution is also very similar to Jonathan's, however if you are not familiar with Regex, contain statements might be a bit more simple to understand. Both work great however! 

 

 

Labels