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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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