Hi, I'm new to here so there's a lot that I don't understand. I have 2 excel spreadsheets that I linked together with a join clause "team number." On spreadsheet 2 we are tracking individual events associated to each team, so the same team numbers are duplicated. The issue is that Tableau is interpreting this by duplicating all of sheet 1's information x amount of times the team number appears on sheet 2. Is there any way around this?
that's the way (inner) join means to do.
after you join 2 tables, you will get a much wider table.
just do your visualization based on the joined result.