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 after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

How do I create additional row(s) of the same data based on column value

viswamtulasi
7 - Meteor

I would like to create additional row(s) of the same data based on column(Rows#) value.

For example of the Input Data –

 

 Name

Location

Rows#

Sam

NY

2

David

NJ

1

Joe

HI

4

 

The out result should be –

Name

Location

Sam

NY

Sam

NY

David

NJ

Joe

HI

Joe

HI

Joe

HI

Joe

HI

  

Is there anyone that can help me get off to the right start with this? Thanks!

3 REPLIES 3
Dynamomo
11 - Bolide

@viswamtulasi

This can be done using the Generate Rows tool.  Right click over the tool (in Preparation category) and open the sample.  The third example in that workflow is very similar to what you are trying to do.

derekbelyea
12 - Quasar

This is how its done.

 

2018-02-26_00012.png

viswamtulasi
7 - Meteor

Thank you so much derekbelyea for your support and it is working !!! 

Labels
Top Solution Authors