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