Merge (LOJ) increasing total value column

[egspen2]

I have a query with financial information (initially16,577 rows) including account name that I'm wanting to merge with a "mapping" query using account name as the common field so that the department from the mapping query is added as a column to my financial data query. When doing a left outer join, the "Expanded Mapping" step (immediately after the merge) is adding 2,440 rows and, in turn, changing (increasing) the total value column in my financial data. Am I doing the wrong type of join? Is there a way to filter out the rows added in the expanded mapping step?

 

[johnny51981]

What I am thinking, in reading your post, is that your Mapping query with the Account Name and Department has Account Names listed more than once.

You have a couple of options:
Cleanest Route: Work on your Mapping Query to scale it down to only having one Department for each Account Name.
Get it done now/Inconsistent Route: In your current step that merges the 2 queries together, keep your Left Outer Join, but click to check "Use fuzzy matching to perform the merge", and then in the Fuzzy Matching Options section, enter the number 1 in the Maximum number of matches (optional) box.

 

[egspen2]

What I am thinking, in reading your post, is that your Mapping query with the Account Name and Department has Account Names listed more than once.

You have a couple of options:
Cleanest Route: Work on your Mapping Query to scale it down to only having one Department for each Account Name.
Get it done now/Inconsistent Route: In your current step that merges the 2 queries together, keep your Left Outer Join, but click to check "Use fuzzy matching to perform the merge", and then in the Fuzzy Matching Options section, enter the number 1 in the Maximum number of matches (optional) box.

Thank you! There were duplicates in my mapping query so I cleaned those up and that fixed it.