Adding Data Rows through Formulas

[Tyler_]

Hello, I have what should be a simple problem but the answer is alluding me.

I am trying to add data rows to my base data set based off of formulas. The example data set would start as the following:

Picked By	Color	Count	Date Picked
Jane	Red	35	6/1/2020
Bob	Yellow	23	5/2/2020
Charlie	Green	16	7/3/2020
Wanda	Blue	41	8/4/2020
Vision	Purple	64	4/5/2020

and the end result that I am trying to get to would be the following:

Picked By	Color	Count	Date Picked	Fruit
Jane	Red	35	6/1/2020	Apple
Jane	Red	35	6/1/2020	Strawberry
Jane	Red	35	6/1/2020	Raspberry
Jane	Red	35	6/1/2020	Cherry
Bob	Yellow	23	5/2/2020	Banana
Bob	Yellow	23	5/2/2020	Lemon
Charlie	Green	16	7/3/2020	Avocado
Charlie	Green	16	7/3/2020	Lime
Wanda	Blue	41	8/4/2020	Blueberry
Vision	Purple	64	4/5/2020	Grape

I have added an example workbook and I can calculate the Fruit column just fine. Where I need help is merging the calculated additions into the original data set to get the final result pictured above.

Any help that can be offered would be appreciated. I suspect it involves the Append Field tool but I can't seem to find the right combination to arrive at the desired result.

[ChrisTX]

Take your several formulas that calculate your new columns for Fruit and store them in a Text Input tool. Then just use a Join tool.

Chris

[afv2688 · Accepted solution]

Hello @Tyler_ ,

you can do this easily by using the generate rows tool.

Regards

[JulioMO]

Hi @Tyler_ 

Why don't you create a master file with the combination of color and fruit and then use a Join Tool? I attach the workflow. 

Regards

[Tyler_]

Thank you all for your replies. The Join method would work, but the generate rows tool is perfect for my specific use case as my next step was to run a date calculation that required the row record. Thank you afv2688 for introducing me to this great tool!