1 of 1 people found this helpful
It may be worthwhile getting a little bit more insight into your actual data structure.
If you have one ID shared across several tables, you should just be able to connect those tables on that ID without getting cross joins. If you make the correct (inner) join, you should end up with a query that has single distinct rows anyway. What sort of database do you have? You could even get a view on your database that has the connection logic in it and just connect Tableau to that view.
I'm not sure what you mean with the ID_1, ID_2, etc, but it would seem unlikely that cross-joins is what you are after as this does not connect tables based on IDs but simply makes any possible connection.
Could you go into more detail as to your data structure and what you're trying to achieve?
Okay the way I have it setup in Tableau is like this. (Oracle).
I add one table, then connect all other tables to it with inner joins on the common ID field. I just add tables until they're all listed.
My problem is my number of records balloons in size, so I can't get accurate results for anything with sums or counts.
I believe this is because some tables have the ID field listed numerous times, each on its own row.