Join - False results

Hi Team,

I have the following workflow

The counts from source 1 is 3271 and from source 2 is approximately 290. I want to get counts same as the left input of 3271 and

reflect the Sum of 31882727 as the final outcome after the join.

However, the final result I get at the last browse tool is 30306677.38 which is incorrect. Can you please help since I want to join the sources just for the text column mapping.

Thanks

JoinIssue.yxmd

Developer

Common Use Cases

Join

Data Investigation

Accepted answers

terry10

@JDong

The solution is attached. Two things needed fixing. (1) remove duplicate codes "system363" from Source2; (2) Union L and J anchors.

JoinIssue(terry10).yxzp

All comments

terry10

@JDong We can't see the source files unless you package them with the workflow (Options--> Export Workflow). But from your description, it sounds like you want to do a left outer join by unioning the J and L outputs (not the J and R as shown in your picture).