14 Replies Latest reply: Jun 7, 2012 3:05 AM by Jason Michaelides RSS

    Creating Feilds

      I have the following code :

       

      qualify *;
      unqualify [Incident ID], WO_Filter;

       

      Workorders_Table:
      LOAD [Incident ID],
           [Owned by Group],
           [WO Number],
           'Has WO' as WO_Filter
          
          
      FROM
      $(FactPath)BI_Workorders.QVD
      (qvd);

       

       

      Which creates a feild WO_Filter which has the option of 'Has WO'

      How would i change this so that the WO_Filter has the option of 'Has WO' and 'Has not WO' ???

       

       

       

       

      BWSBpJ3yqualify *;
      unqualify [Incident ID], WO_Filter;

      Workorders_Table:
      LOAD [Incident ID],
           [Owned by Group],
           [WO Number],
           'Has WO' as WO_Filter
          
          
      FROM
      $(FactPath)BI_Workorders.QVD
      (qvd);
      qualify *;
      unqualify [Incident ID], WO_Filter;

      Workorders_Table:
      LOAD [Incident ID],
           [Owned by Group],
           [WO Number],
           'Has WO' as WO_Filter
          
          
      FROM
      $(FactPath)BI_Workorders.QVD
      (qvd);