how to add data from another table in new column itteratively

[kams01]

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!

[ChrisTX · Accepted solution]

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

[ChrisTX]

In the Append Fields tool, change the configuration option at the bottom to Allow All Appends.

[grazitti_sapna]

Hi @kams01 , change the option to allow all appends, please refer to the screenshot.

Thanks.