2 Replies Latest reply on Oct 22, 2012 2:57 AM by Philip George

    Full Outer join

    Philip George

      Hi,

       

      How can I apply full outer join in Tableau through custom SQl.

       

       

      Regards,

      Philip George

        • 1. Re: Full Outer join
          sirajmandayippurath

          Hello Philip,

           

          Have you tried the options listed on this knowledge base article?

           

          If you let us know any further specific issues are facing, I am sure we could help you!

           

          Cheers

          Siraj

          • 2. Re: Full Outer join
            Philip George

            Thanks Siraj,

             

            I saw that article.it was helpful.

            I have one query.

             

            I have 3 tables One main Table(A) and two sub tables(B and C).

             

            In table A there is a unique column(CL1)

            In table B and C CL1 is present but that is not unique.So basically a 1:N join is happening between table A to B and Table A to C.

            There is no other composite key also present between these tables.

            if I do some calculations like sum(<any measure in table A>).the value I am getting is more because number of rows have increased.

            Is there any way I can do a sum(distinct <measure in tableA>).

            I tried it.but it is not working.I am using Tableau public.

             

            Is there any other ways to solve the issue?

             

             

            Regards,

            Philip George