In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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