SPLIT rows based on row value

[flojosx]

Hi All, 

I have to generate Consumer IDs based on the number of customers in a category. So I like to go from 

Group	No. of costumers
A	2
B	3
C	5

To

ID	Group	No. of costumers
ID10001	A	2
ID10002	A	2
ID10003	B	3
ID10004	B	3
ID10005	B	3
ID10006	C	5
ID10007	C	5
ID10008	C	5
ID10009	C	5
ID10010	C	5

I tried the generate row tool but somehow I got way too many records. Any help would be appreciated. Thank you so much for your help.

[neilgallen · Accepted solution]

Using the generate rows tool along with a record I’d would get you the results you need.

You could use the generate records tool where the condition is <= your number of customers field. All other values could be the same as the default.

After making the right number of rows, then add a record ID tool to make your ID field.

[flojosx]

Thanks you so much for the quick reply! this worked. I was doing the same thing but was using a min (0) and max (customer number) column which resulted in waaaay too many column. the defaults worked. Thank you!

[Thableaus · Accepted solution]

Hi @flojosx 

Here's a possible way to do it:

- Use generate rows to generate the row until No. of Customers (RowCount <= [No. of costumers])

- Use RecordID starting at 10000, string size of 5

- Change the string size to 7, remove RowCount with the Select Tool

- Use Formula Tool to add the "ID" string to Record ID

WF attached.

Cheers,