Blending three data sources with one of them having only a single value per key

[matoduri]

I'm building a dashboard that blends three tables:

• identifiers of athletes

• db pulled from Strava: one row = one activity in a given time frame

• manually tracked activity sheet: one row = kms for all the activities in a given time frame

The problem is that the one row with kms for all the activities in a given time frame gets multiplied by the count of activities pulled from strava, as it's added to every single row of the blended data set.

Any ideas how I can make sure that sum of manually tracked kms is pulled only once and added to the total number of km pulled from Strava?

Many thanks!

[sam8]

It sounds like you may have joined table 3 to table 2 rather than to table 1! Try joining both tables to table 1, that might help your fanout.