1 Reply Latest reply: Jan 13, 2011 4:42 PM by Dinesh Thoniparambil RSS

    Joining tables where part of join is a date within a date range

      I am relatively new to QV and haven't seen a solution to an issue I'm having. I have several fact tables that are organized by keyfield1 and date. These tables join to a lookup / dimension table which has a primaryID, keyfield1 and a start and end date range.

      I want to associate / link the keyfield1 and date selection to a primaryID where keyfield1 is a match and the fact table date is in between the start and end dates of the lookup table.

      I am loading data from SQL but can't preprocess this on the SQL side but am unsure how to do this within a QV load process.

      thanks,

      Pete