Forum Discussion
Join is duplicating rows for right table
I have two tables that are parts of a inner.join table merge.
The join is on two columns, date & Template Name (called Ad Content in left table)
After the join, the left table portion of the merge is missing data & the right table portion of the join has multiplied data.
As you can see below - The merged figurs as the the top match neither the left table nor the right table.
Does anyone know what I'm doing wrong?
2 Replies
AlfredASC can you make sure there is no summarization used in table view for these columns. There could be more rows and if summarized is used, you are not going to seeing raw number.
To change summarize, click arrow next to column in values section where you dropped the columns and change it to Don't Summarize
Could you show data with dates column as well. And did you use Fuzzy Match on the join?
