Can't Join two data sets

[Mostafa_Anwar]

Hi All,

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

Example of Plan Data set

   

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  

Any help will be a highly appreciated.

Regards,

[Thableaus]

Hi @Mostafa_Anwar 

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,

[Mostafa_Anwar]

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

[Thableaus · Accepted solution]

@Mostafa_Anwar 

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,