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

    Data blending: blending based on condition?

    Gengming Chen

      Hi,

       

      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!

       

      Leo