A Question about total no of records

[prakashatutd]

Hello:

In the attached workflow, 

1. the output of Summarize has total 1436 records
2. the combined outputs of the Unique records total 1436
3. BUT the total number of the Join tool (L + J + R)  is 1437.-->  (one more) than in # 1 and # 2 above.

Question: Why is this discrepancy 146 Vs 1437

[binuacs]

@prakashatutd upload the input file as well

[prakashatutd]

Aah -- Sorry that I missed files. (New to Alteryx. Wrongly assumed that the .yxmd files also append data files

Now attached --

[Raj · Accepted solution]

@prakashatutd 
the reason of getting one extra record is "Catvideofest"
because in the duplicate tab this record is getting repeated twice and while joining, they are joined to 1 record from the "U" anchor
this is because many to many joins in the join tool.
so, there is nothing wrong

just for example
If your L anchor has 1,1,1 and R anchor has 1,1,1 this will produce 9 lines of output

hope this helps to understand
mark done if solved.

[stataltgee]

@prakashatutd I run the wf and this was the output.

Union tool : 1613

Summarize tool: 1441