Combine tables with missing rows and apply formula
Aug 10, 2018 11:36 AM
| Last Modified: Aug 10, 2018 11:56 AM(3142 views)
I have two data sets. One is an average of insect counts that were done in a plot weekly or biweekly. The other is the yield that was measured every week. I'm trying to combine these two data tables so that I can analyze the impact of insects on yield.
I have this:
And I'm trying to produce this in JMP.
Note that for week 44 and 45 I simple move the Yield value over, but for week 47 I need to sum Yield from weeks 46 and 47. The same for week 49. For week 52 I sum the yield from weeks 50-52.
I have many plots and uneven weeks of insect and yield sampling.