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

Question

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

EFG 3 4 5 6 EFGH 1 2 3 4

HIJ 1 2 3 4 KLMN 2 3 4 5

Thank you for your help!!!!

apathetichell · Answer

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

binu_acs · Answer

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

apathetichell · Answer

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