Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Converting one row into many

sebasgj
7 - Meteor

Hello,

 

I wanted someone help into this issue, I have this data as aggregates it tells me that there were a total of 3 conversions where the media X and Y where present, what I want is to repeat the amount of rows with the number of conversions, I have many other media with different conversions

 

 

Media 1 | Media 2 | Conversions

X Media | Y Media |  3

Z Media | P Media |  2

 

Result Desired

Media 1 | Media 2 | Conversions

X Media | Y Media |  1

X Media | Y Media |  1

X Media | Y Media |  1

Z Media | P Media |  1

Z Media | P Media |  1

 

If someone has an idea please let me know.

 

Thank you

2 REPLIES 2
Storm
9 - Comet

I think GENERATE ROWS tool is the way to go.  Would attached workflow work?

sebasgj
7 - Meteor

Sure,

 

 

Labels
Top Solution Authors