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!

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

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!

Developer Tools

Best Practices

Transformation

Accepted answers

viswamtulasi

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

All comments

Dynamomo

@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

This is how its done.

MULTIPE ROWS.yxmd

viswamtulasi

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

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335