repeat record "n" times

[dsouthh]

Hello Community,

Let's say I have ten records, each with three fields. The first field will be a unique customer ID and then the remaining two fields are items purchased by this customer: one item per field.

For each customer, I want to have a separate record for each item. In the end, there will be twenty records but with only two fields.

The first step I've chosen to take is to use two select tools. One of them will select the customer IDs and the other select tool selects the purchases. The purchases are then transposed organizing them in a way I want. I now want to append this transposed table to the customer IDs but first I need to be able to duplicate each ID.

Is there a way to duplicate a record any amount of time? Is there a more creative way of doing this?

Thank you.

[MarqueeCrew · Accepted solution]

Do try the Transpose tool!

https://help.alteryx.com/11.3/index.htm#Transpose.htm

[NicoleJohnson · Accepted solution]

Can you just use the Transpose tool on the original data, grouping by Customer ID? See below... is that what you're looking for? You could deselect the Name column after transposing, and that would give you your CustomerID + List of items in just the two columns.

Original Data:

CustomerID	Item1	Item2
123	A	D
456	B	E
789	C	F

Results:

NJ

[mborriero · Accepted solution]

Hi, try to have a look at the generate rows tool. It will duplicate rows as many times as you want, based on your loop.

Get Outlook for iOS

[dsouthh]

Now I know how to use the transpose tool properly... thank you