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