1 Reply Latest reply on Oct 18, 2018 10:08 AM by patrick.byrne.0

    JOIN com "OR"

    Guilherme Bandeira Luz
    Guilherme Bandeira Luz Sep 19, 2018 2:15 PM

      Boa tarde,

       

      Tudo bem?

       

      Estou com uma dificuldade para implementar um JOIN, a minha situação é a seguinte: Estou na fonte de dados tentando fazer um relacionamento a partir de três chaves Data de Abertura, Data de Resposta e Data de Finalização, preciso relacionar com uma dimensão de data se alguma destas datas existe.

      Em banco de dados montaria assim:

       

       

      SELECT *

      FROM

           FATO F

           JOIN DATA D

                ON ( (F.DATA_ABERTURA = D.DATA) OR

                         (F.DATA_RESPOSTA = D.DATA) OR

                         (F.DATA_FINALIZACAO = D.DATA)

                       )

      Montei um script básico do cenário que estou tendo.

       

      Muito obrigado,

      Guilherme

        • 1. Re: JOIN com "OR"
          patrick.byrne.0
          patrick.byrne.0 Employee Oct 18, 2018 10:08 AM (in response to Guilherme Bandeira Luz)

          Hello Guilherme,

           

          The ability to JOIN on an OR clause in Tableau is currently a feature request. Please vote up the idea in the Tableau Community forums: https://community.tableau.com/ideas/3735

           

          Additinoally if this is being performed in a Custom SQL connection. Please test Tableau Desktop and the Custom SQL query by performing the following steps.

           

           

          1. Obtain the query in question to be tested against the data source outside of Tableau Desktop with the SELECT (*) wrapper as listed below. 

           

          The query Tableau Desktop usually sends looks like this:

           

             SELECT Test_SQL.* FROM

                   ( CUSTOMER'S CUSTOM SQL ) Test_SQL

           

          Be sure to include the ().

           

          Does the query complete successfully? If so there might be something occurring with Tableau Desktop when attempting to executre the query. Please also include any error messages that occur while attempting the join.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick