cancel
Showing results for 
Search instead for 
Did you mean: 

Transpose rows under 1 field and concatenate with values from different fields

SOLVED
JoRao
Atom

Hello All - This is my first post here. I am trying to convert the rows under one field to different  field names and concatenate each field name that was derived from rows with other field names. I have attached a sample worksheet showing what I want my end product to  look like.

 

Thanks in advance for your help!

 

  • Output
Alteryx
Alteryx

Hi @JoRao

 

Please find a workflow attached which can show you how to manipulate your data.

 

Pic4.png

 

Some of these techniques such as the two tool containers at the end can be replicated once you add product 2, 3 & 4 in the data.

 

Best,

 

Jordan Barker

Solutions Consultant 

JoRao
Atom

Hi @JordanB,


Thank you for your response. I guess I was not very clear in describing what it is that I want to achieve. If we looked at row 1-4 on the excel sheet I attached, I want to be able to concatenate the field names (Avg, Product1, etc,.) to the values in the first row (manual PMPM, PCC PMPM, etc.) So my end result would have field names that look like this:

 

 

Avg Man PMPM **, Avg PCC PMPM **, Avg Right PMPM ** ,Avg Final PMPM ** ,Product 1 Man PMPM **  etc.

 

How would I achieve this in Alteryx?

 

Thanks again for your help!

 

Best,

Jo

Alteryx
Alteryx

Hi @JoRao

 

My fault for not interpreting correctly. 

 

Again similar techniques will be used but the key is to pivot the data so your field headers and 'Avg Man etc. are side by side. You can then concatenate the field headers and avg etc. values together and then pivot the data to your ideal format. 

 

Attached is a workflow you can use as a basis.

 

Best,

 

Jordan Barker

Solutions Consultant

JoRao
Atom

This is awesome!! Thank you so much for your help @JordanB!!