Apply a process for each item (batch Macro)

[Phoowan]

HI Community, 

I have this use case whereby I need to iterate over a list of cities an apply a couple of formulas and multi row formulas. 

In this example, 

Dataset 1: City (100) + Value 

Dataset 2: Assumptions for years 2023 + 2024 

The output should be a dataset that contains the processed formulas for each city per year.

So i tried to build a batch Macro for this but its not working. I hope someone can help me with this usecase. 

Maybe I shouldn't do a batch macro? 

[PhilipMannering · Accepted solution]

This should work. If not, you should give an example of the expected output for one of the cities.

[ed_hayter · Accepted solution]

Happy to look into doing this with a macro but for now I went ahead and calculated with an append as I was not quite sure we needed anything else given the calculations happen on the row level.

Let me know if this is not what you wanted.

[Phoowan]

Wow, I learned a lot here! I struggled with this for like days. 
This is great and a good example for using the append fields tool. 

Many thanks!