the issue you are running into is in your join. because you joined on the code field tableau is building an outer join. your results look like the below. so when you display aspecto, colores is using all of the corresponding latitude and longitude values of hoja11. what you need to do to solve this is union the files together.
Aspecto Aspecto (Hoja11) Codigo Codigo (Hoja11) Latitud Latitud (Hoja11) Longitud Longitud (Hoja11) Number of Records Colores Rojo 1 1 -2.65336 -2.77735 37.33242 37.23839 1 Colores Naranja 1 1 -2.65336 -2.70068 37.33242 37.19678 1 Colores Negro 1 1 -2.65336 -2.13354 37.33242 37.30341 1 Colores Azul 1 1 -2.65336 -3.14008 37.33242 36.78782 1 Colores Verde 1 1 -2.65336 -2.78442 37.33242 37.09354 1
version 10.1 allows you to do a wildcard union. versions prior to 10.1 you would need to follow the below link.
Hello Chris, thank you very much for your answer.
Is this the only way to solve this (master-detail)?
I mean if you have lots of tables related with millions of records within an Oracle system, making a UNION is not the most advisable (this is my case).
Thank you very much again
the only way to accomplish the analysis you are trying to do would be to get all of the aspectos in a single field or list for tableau to reference.