3 Replies Latest reply on Jan 1, 2018 10:47 PM by ashwini raju

    Data blending: blending based on condition?

    Gengming Chen



      I am wondering if anyone else have similar issues:



      In SQL, you can do a conditional join, example,


      LEFT JOIN on Dim_Date d on SomeThing.Key = d.key

      and Something.date >= d.StartingDate

      and Something.date <= d.EndingDate


      In this case, the join depends on date to be within Starting and Ending  date range from Dim_date.

      However, I am not sure how to define a blending to allow this to happen since blending only asks the filed blended and not on how.


      Appreciate any thoughts or idea!