Duplicating Data

Da_Norman

Hello,

I need to duplicate my data in the exact format it is currently in my data set. Please see the following example

Original Data:

A

B

C

New Format:

A

B

C

A

B

C

Ideally I would be able to choose how many times this data is duplicated or set a limit for how many times it can duplicate. Please respond back with any potential solutions other than using the union to combine from my data source multiple times.

danilang

Hi @Da_Norman 

I'm a big fan of NOT using macros if there is a simple way to accomplish the task without one.  Macros complicate the workflow and increase maintenance effort.  This is a case where a few tools can produce the results that you want.

Here I add a RecordID and then a Group field set to 1.  The Generate Rows creates the requested number of groups.  The Sort orders as per the inpput and the final Select removes the RecordId and Group fields leaving only duplicates of your original data.

Dan

CreateNDuplicates.yxwz