2 Replies Latest reply on Nov 21, 2016 12:06 PM by D P

    Custom SQL Query add Excel lookup file

    D P

      Just a quick question. I am building some Tableau (versions
      10) reports.

       

      I have Custom SQL Query based on one of SQL Server databases
      (a few tables joined).

      So, now I want to add one Excel lookup file to the already
      existing Custom SQL Query.

       

       

      I was able to join those two via => Data…Edit
      Relationships ….but the join between SQL Server table and Excel is more complex
      and it is not E.Col1 = D.Col1

       

      It is more like this

       

       

      1. E.ST   >= D.ST and
      2. E.END   >= D.END

       

      Where E is excel file and D is SQL Server database…

       

       

      I appreciate for any help