1 Reply Latest reply on Dec 15, 2016 2:23 PM by Matthew Risley

    Possible to join across data sources on a date range?

    Chelsey Lyman

      I have a view in SQL server A that I need to join onto a table in SQL server B. This will require a join on multiple columns. The first is just an account number, and is a straight 1:1 match in each table. However, I also need to join a single date column from the view in server A onto a range of dates spread across two columns in the server B table. Does anyone know if this is possible to do in Tableau join functionality? The SQL servers are not linked, so I was hoping to avoid using the Custom SQL option. Thanks.