community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Generate rows for values in multiple fields

Asteroid

Hi there,

 

I have some data that currently looks like this:

Capture.PNG

 

 

However, I would like to split Paris into two rows, one row for rank B and one for rank C:

Capture.PNG

 

 

I have got close to this by using the Generate Rows tool, so Paris now shows on two separate rows but it contains values for both B and C:

Capture.PNG

 

 

How can I get Alteryx to remove the C from the first row and the B from the second row? Obviously this is only sample data - the real data will include multiple cities and multiple rankings so I need something generic and replicable. Hopefully there is a solution!

 

 

Pulsar

How about this?

 

count.png

Very similar to @DavidP but just grouping on Name as well as using as the field name.

2018-10-24_11-18-54.png

Asteroid

Thanks @DavidP and @jdunkerley79, that works well

Labels