Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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