3 Replies Latest reply on Jul 18, 2016 4:43 AM by ravi.vankayala

    How do we resolve the duplicte data issue when joining multiple tables from same datasource

    ravi.vankayala

      Hi all,

      How do you resolve the duplicate data issue when joining multiple tables from same datasource.? I am using sql server database.

      I am using data blending for now to make it work. But  I have gone through some links in tableau where it says to change aggregation from sum to avg but it didn\t worked for me.

       

      due to one to many relationships when I join all the 6 tables the data is getting duplicated. So any other idea to resolve this issue.Will cross database joins help this scenario which is a new feature in tableau 10?

       

      thanks in advance.