Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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