Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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