I have a data set that specifies a list of values and the number of times to "copy" them. For example,
| Fruit | Copy Num |
| Apple | 2 |
| Orange | 4 |
| Banana | 3 |
The output set I'm trying to achieve is this:
| Fruit |
| Apple-1 |
| Apple-2 |
| Orange-1 |
| Orange-2 |
| Orange-3 |
| Orange-4 |
| Banana-1 |
| Banana-2 |
| Banana-3 |
I looked into the Multi-Row Formula tool but wasn't able to figure out how to go about doing this. Does anyone have any suggestions?
Solved! Go to Solution.
Clutch!, thank you!
Brilliant, I needed a very similar solution - but mine was because the "count" needed to combine with the "unique string" to get a field with "unique string.1,...,unique string.count".
I wasn't sure if my data had unique rows so I added a record ID before I duplicated the rows, before including that in the "group by" and "concatenate" steps to get what I needed.
Never used the generate rows tool before, very helpful!
