Can't Join two data sets

Hi All,

I am struggling to join two data sets "Plan & Sales" however the duplication issue encountered:

Example of Plan Data set

Plan SC.jpg

Example of Sales Data Set:

When i joined these data sets based on Product below is the output with duplication issue Also

Note: Date field type is V_String

Output SC.jpg

Any help will be a highly appreciated.

Regards,

Workflow

Accepted answers

From what I see here you need to do a Left Join, using Product, Team and Date as Key fields to join.

First you bring the Join Tool, then you bring the Union Tool, unioning the Left Anchor (L) with the Join anchor (J).

The Left table would be the first one, the one that has the 'Plan' Column with all dates.

Cheers,

Are you using Date as a joining field as well?

It seems like you're just using Product as a Key field to join.

Cheers,

Thanks for your respond, Apologize i forgot to attach how i can achieve the output below after joining the two data sets