Generate rows question

[zperry]

Good afternoon Alteryxnation! Was hoping someone could help me out with a generate rows question. I have a list of salespeople and a list of products. I need to generate rows so that each salesperson has a separate row for each product. So if I have 3 sales people and 3 products, I need to generate 9 rows.

Record | Salesperson | Product

1                    A                   1

2                    A                   2

3                    A                    3

4                   B                     1

5                    B                     2

and so on.

Appreciate the help!

[Qiu]

@zperry 
The table you have here is the output or input?

[mot · Accepted solution]

Hi @zperry ,

I have attached the workflow.

I hope this helps. Best.

[zperry]

AH! Thanks. I figured I might be trying to use the wrong the tool! No wonder it was so hard. 🙂

[Qiu]

@zperry 
maybe like this?