I'm looking for a bit of help here. I'm newer to data merging and I'm running into a particular problem! I'm importing the data from Excel (2 tables) and there was no unique identifier with no duplicates between them, so I created a join column so that they could be merged through a left outer. It worked! BUT- in each table there is a column for 'score'. Table 2 has multiple entries for errors (line items) related to a single data point in Table 1. So, the issue is post-merge is that the score is pulled in and counted for each error or line item where I only need 1 instance of the score so that I can average the values correctly.
I have an example here.
The left visual shows an un-merged dataset and therefore what the actual average of score should be. The one on the right shows what I am dealing with post-merge. I've included COUNT of the score to show the issue. The data has to be sorted by Language,