SPLIT rows based on row value

Question

Hi All,

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

GroupNo. of costumersA2B3C5

To

IDGroupNo. of costumersID10001A2ID10002A2ID10003B3ID10004B3ID10005B3ID10006C5ID10007C5ID10008C5ID10009C5ID10010C5

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 Answer

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.

Thableaus · Accepted Answer

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,