Data Blending

Integrate the two tables into a new table, and finally add a column of average values.

Accepted answers

Is this your assignment? 😁
lets get you started.
Based on your results., you are looking at the difference between Year 2017 and 1997 actually, not the average.

example-R1.yxmd

All comments

Hi @DDYY, you can integrate the two tables using the Join tool (something like the screenshot below), and then introduce a formula tool downstream to compute the avg.

Is this your assignment? 😁
lets get you started.
Based on your results., you are looking at the difference between Year 2017 and 1997 actually, not the average.

example-R1.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

Hollingsworth 335