Generating identical rows for different people

[Deano478]

Hi Folks,

Generating rows is something I was never great at in Alteryx and today I have a use case where I need to use it and I'm unsure as to how it can be done.

Essentially I want to be able to generate 12 identical rows for a list of people like this:

I have a list of 4 names and I just need to create the below for output for those 4 people.

I appreciate your help and for you taking the time to look at this question. 

Thanks in advance

Name	Period	Amount
Dean	1	0
Dean	2	0
Dean	3	0
Dean	4	0
Dean	5	0
Dean	6	0
Dean	7	0
Dean	8	0
Dean	9	0
Dean	10	0
Dean	11	0
Dean	12	0

[ShankerV · Accepted solution]

Hi @Deano478 

One way of doing this.

Input was:

Many thanks

Shanker V

[Deano478]

@ShankerV Cheers for that It's the one tool I can never get my head around 

[ShankerV]

Hi @Deano478 

Might be the below will help along with playing with the tool for other scenario's.

https://help.alteryx.com/20223/designer/generate-rows-tool

Also the below will help, Right click on the Generate rows tool.

Many thanks

Shanker V