Generating 3 additional duplicate rows for each incoming row...

[kkkim]

Hi, All! Wondering if you can help output three additional duplicate rows for each incoming row. The number of rows will vary each run (so # of records should be dynamic, the dataset is large). I need to replicate all columns for each row - and create three additional rows below the original row. Example below:

Input Dataset

ABD 2 3 4 5 ABCD 5 6 7 8

EFG 3 4 5 6 EFGH 1 2 3 4

HIJ 1 2 3 4 KLMN 2 3 4 5

Output Dataset

ABD 2 3 4 5 ABCD 5 6 7 8

ABD 2 3 4 5 ABCD 5 6 7 8

ABD 2 3 4 5 ABCD 5 6 7 8

ABD 2 3 4 5 ABCD 5 6 7 8

EFG 3 4 5 6 EFGH 1 2 3 4

EFG 3 4 5 6 EFGH 1 2 3 4

EFG 3 4 5 6 EFGH 1 2 3 4

EFG 3 4 5 6 EFGH 1 2 3 4

HIJ 1 2 3 4 KLMN 2 3 4 5

HIJ 1 2 3 4 KLMN 2 3 4 5

HIJ 1 2 3 4 KLMN 2 3 4 5

HIJ 1 2 3 4 KLMN 2 3 4 5

Thank you for your help!!!!

[apathetichell]

attach a generate rows tool - set the loop to run while rowcount<=3

[binuacs]

@kkkim as @apathetichell mentioned you need to add the row generate tool and set the record count <=4

[apathetichell]

@binuacs thanks for the math assist. This is one of those word problems that my kids do.