Hello 1st time posted long time reader I have a table, snapshot below: Budget CategoryForecast Plan TypeCapSpendCategoryCarryover5G mmWSoft Costs - Entitlement ServicesCarryover5G mmWHard Costs - Services OOSCarryover5G mmWHard Costs - Services Add OnCarryover5G mmWHard Costs - ServicesCarryover5G mmWHard Costs - RAN EquipmentCarryover5G mmWHard Costs - Ancillary EquipmentCarryoverAASSoft Costs - Entitlement ServicesCarryoverAASHard Costs - Services OOSCarryoverAASHard Costs - Services Add OnCarryoverAASHard Costs - ServicesCarryoverAASHard Costs - RAN EquipmentCarryoverAASHard Costs - Ancillary Equipment Basically I need to add 2 columns, 1 that has Region, and other has City names. I need to create copies of the above table as many times over and append them to a larger table as there are region/city combination. So the result should look like: Budget CategoryForecast Plan TypeCapSpendCategoryRegionCityCarryover5G mmWSoft Costs - Entitlement ServicesWestLACarryover5G mmWHard Costs - Services OOSWestLACarryover5G mmWHard Costs - Services Add OnWestLACarryover5G mmWHard Costs - ServicesWestLACarryover5G mmWHard Costs - RAN EquipmentWestLACarryover5G mmWHard Costs - Ancillary EquipmentWestLACarryoverAASSoft Costs - Entitlement ServicesWestLACarryoverAASHard Costs - Services OOSWestLACarryoverAASHard Costs - Services Add OnWestLACarryoverAASHard Costs - ServicesWestLACarryoverAASHard Costs - RAN EquipmentWestLACarryoverAASHard Costs - Ancillary EquipmentWestLACarryover5G mmWSoft Costs - Entitlement ServicesEastNYCarryover5G mmWHard Costs - Services OOSEastNYCarryover5G mmWHard Costs - Services Add OnEastNYCarryover5G mmWHard Costs - ServicesEastNYCarryover5G mmWHard Costs - RAN EquipmentEastNYCarryover5G mmWHard Costs - Ancillary EquipmentEastNYCarryoverAASSoft Costs - Entitlement ServicesEastNYCarryoverAASHard Costs - Services OOSEastNYCarryoverAASHard Costs - Services Add OnEastNYCarryoverAASHard Costs - ServicesEastNYCarryoverAASHard Costs - RAN EquipmentEastNYCarryoverAASHard Costs - Ancillary EquipmentEastNY Copy paste could take a while with several combination. Is there an easy way to do this? Thanks in advance!

how to add data from another table in new column itteratively

Hello

1st time posted long time reader

I have a table, snapshot below:

Budget Category	Forecast Plan Type	CapSpendCategory
Carryover	5G mmW	Soft Costs - Entitlement Services
Carryover	5G mmW	Hard Costs - Services OOS
Carryover	5G mmW	Hard Costs - Services Add On
Carryover	5G mmW	Hard Costs - Services
Carryover	5G mmW	Hard Costs - RAN Equipment
Carryover	5G mmW	Hard Costs - Ancillary Equipment
Carryover	AAS	Soft Costs - Entitlement Services
Carryover	AAS	Hard Costs - Services OOS
Carryover	AAS	Hard Costs - Services Add On
Carryover	AAS	Hard Costs - Services
Carryover	AAS	Hard Costs - RAN Equipment
Carryover	AAS	Hard Costs - Ancillary Equipment

Basically I need to add 2 columns, 1 that has Region, and other has City names. I need to create copies of the above table as many times over and append them to a larger table as there are region/city combination.

So the result should look like:

Budget Category	Forecast Plan Type	CapSpendCategory	Region	City
Carryover	5G mmW	Soft Costs - Entitlement Services	West	LA
Carryover	5G mmW	Hard Costs - Services OOS	West	LA
Carryover	5G mmW	Hard Costs - Services Add On	West	LA
Carryover	5G mmW	Hard Costs - Services	West	LA
Carryover	5G mmW	Hard Costs - RAN Equipment	West	LA
Carryover	5G mmW	Hard Costs - Ancillary Equipment	West	LA
Carryover	AAS	Soft Costs - Entitlement Services	West	LA
Carryover	AAS	Hard Costs - Services OOS	West	LA
Carryover	AAS	Hard Costs - Services Add On	West	LA
Carryover	AAS	Hard Costs - Services	West	LA
Carryover	AAS	Hard Costs - RAN Equipment	West	LA
Carryover	AAS	Hard Costs - Ancillary Equipment	West	LA
Carryover	5G mmW	Soft Costs - Entitlement Services	East	NY
Carryover	5G mmW	Hard Costs - Services OOS	East	NY
Carryover	5G mmW	Hard Costs - Services Add On	East	NY
Carryover	5G mmW	Hard Costs - Services	East	NY
Carryover	5G mmW	Hard Costs - RAN Equipment	East	NY
Carryover	5G mmW	Hard Costs - Ancillary Equipment	East	NY
Carryover	AAS	Soft Costs - Entitlement Services	East	NY
Carryover	AAS	Hard Costs - Services OOS	East	NY
Carryover	AAS	Hard Costs - Services Add On	East	NY
Carryover	AAS	Hard Costs - Services	East	NY
Carryover	AAS	Hard Costs - RAN Equipment	East	NY
Carryover	AAS	Hard Costs - Ancillary Equipment	East	NY

Copy paste could take a while with several combination. Is there an easy way to do this? Thanks in advance!

Preparation

Accepted answers

ChrisTX

Use a Text Input tool to store your values for Region and City. Then use the Append Fields tool to combine your table with the data from the Text Input.

Chris

All comments

ChrisTX

Use a Text Input tool to store your values for Region and City. Then use the Append Fields tool to combine your table with the data from the Text Input.

Chris

kams01

Thanks!

I am getting an error that there were more than 16 records in the source. Any idea why?

Attached is the workflow

test.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703