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 ByColorCountDate PickedJaneRed356/1/2020BobYellow235/2/2020CharlieGreen167/3/2020WandaBlue418/4/2020VisionPurple644/5/2020 and the end result that I am trying to get to would be the following: Picked ByColorCountDate PickedFruitJaneRed356/1/2020AppleJaneRed356/1/2020StrawberryJaneRed356/1/2020RaspberryJaneRed356/1/2020CherryBobYellow235/2/2020BananaBobYellow235/2/2020LemonCharlieGreen167/3/2020AvocadoCharlieGreen167/3/2020LimeWandaBlue418/4/2020BlueberryVisionPurple644/5/2020Grape 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. Adding Rows.yxmd

Adding Data Rows through Formulas

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.

Adding Rows.yxmd

Developer

Accepted answers

afv2688

Hello @Tyler_ ,

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

Regards

condition_add_rows.yxmd

All comments

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

Hello @Tyler_ ,

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

Regards

condition_add_rows.yxmd

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

Adding Rows2.yxmd

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703