topic Re: How do I create additional row(s) of the same data based on column value in Alteryx Designer Desktop Discussions

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

viswamtulasi — Thu, 24 May 2018 04:56:08 GMT

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!

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

Dynamomo — Tue, 27 Feb 2018 06:44:34 GMT

@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.

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

derekbelyea — Tue, 27 Feb 2018 07:03:14 GMT

This is how its done.

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

viswamtulasi — Tue, 27 Feb 2018 07:14:31 GMT

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