1 Reply Latest reply: Dec 12, 2012 2:36 PM by mayilvahanan ramasamy RSS

    Filtering a Load Table

      I am doing a load using the following script and would like to do further filtering based on one of the fields in the load. I am trying to only show data where the Time_Month_Key is equal to the Current Month

       

      The Time_Month_Key is formatted as 'YYYYMM'

       

      How would I write the filter to do this? (See Section in Red Below)

       

      HierarchyLookup:
      Load
      
      'Business_Unit',
      'Director',
      'Manager',
      'Rep',
      'Reporting_Team',
      'Time_Month_Key',
      'VP'
      
      Resident vw_EOM_Sales_Leads_Metrics_Detai
      where Time_Month_Key = date(Now());
      

       

      Thanks

       

      Tim