4 Replies Latest reply on Nov 28, 2018 4:51 AM by Pau Tur

    Can I join two tables where a date in the first one is between two dates in the second one?

    Pau Tur

      That's it. I have two tables. The first one represents executions of processes, and it has Starting Date and Ending Date of the execution. The second table represents each executed process, and has its hour of execution, which is between the Starting Date and Ending Date of the execution in the first table. So there are no common IDs between tables or other common fields to join, however I could retrieve the desired information with the following rule:

       

      Starting Date (table 1) <= Hour of execution (table 2) <= Ending Date (table 1)

       

      Is there a way to do this? I'm using Tableau Desktop Professional 2018.1.2. Thanks in advance!