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.
Solved! Go to Solution.
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!
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,