How would I duplicate Territory Name and Number So that I can add the specific Coverage and Product TerritoryNumberTerritoryNamecoverageproduct123Joe smithproductApple1454John 145Harry 13434Joyce Desired Results TerritoryNumberTerritoryNamecoverageproduct123Joe smithproductApple123Joe smithcustomerApple

HELP - Need to create duplicate rows in a column

How would I duplicate Territory Name and Number So that I can add the specific Coverage and Product

TerritoryNumber	TerritoryName	coverage	product
123	Joe smith	product	Apple
1454	John
145	Harry
13434	Joyce


Desired Results
TerritoryNumber	TerritoryName	coverage	product
123	Joe smith	product	Apple
123	Joe smith	customer	Apple

Workflow

Accepted answers

echuong1

Are you trying to just create two rows for each Territory Number and Name combination?

If so, you can create a reference list with the coverage areas you want to include and then use the Append Fields tool to add them in.

See attached for an example. Let me know if this is what you're looking for!

New Workflow7.yxmd

All comments

StephV

Hi @DonnaFazio,

Thank you for your contribution to the Community! Just wanted to give you a heads up that I have moved your message to the Designer Discussions board for more visibility. In the future, feel free to start a new conversation in the Discussions section if you have any other questions.

Let us know how it goes!

neilgallen

there are a number of different ways to go about this, depending on your data. Can you provide a more detailed example dataset? It looks like you want duplicate rows for each territory number and territory name for differing coverages and products.

Is there a defined list of each coverage and product?

Will each territory number / name have every combination or can they have unique lists?

echuong1

Are you trying to just create two rows for each Territory Number and Name combination?

If so, you can create a reference list with the coverage areas you want to include and then use the Append Fields tool to add them in.

See attached for an example. Let me know if this is what you're looking for!

New Workflow7.yxmd

DonnaFazio

Thanks so much! This was what I was looking for

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703