3 Replies Latest reply: Feb 3, 2015 8:59 AM by Jonathan Greene RSS

    Bring in only NULL Values to a QVD

      I am pulling from SAP and I need to only pull data in based upon a field CUST_GRP3 where there is no data in the field, I tried a few things but can't seem to bring in the expected results.  Basically I only want to return values that are NULL in CUST_GRP3 .   Here is my script:

       

       

      VW_R_NAM_CUST_SALES_ORG:

       

      LOAD SAP_CUST_NBR,
      SALES_ORG,
      DIST_CHANNEL,
      DIVISION,
      CUST_NAME,
      STREET,
      CITY,
      STATE_PROV,
      POSTAL_CODE,
      CNTRY_CD,
      CUST_GRP1,
      CUST_GRP2,
      CUST_GRP3,
      CUST_GRP4,
      CUST_GRP5,
      CUST_GRP,
      SO_AUTH_GRP,
      SO_DELETE_IND,
      SO_ORDER_BLOCK_CD,
      PRICE_GRP,
      PRICE_LIST,
      INCOTERMS,
      INCOTERMS2,
      SO_DELIVERY_BLOCK,
      SHIP_COND,
      SO_BILLING_BLOCK_IND,
      CURR_CD,
      ABC_CD,
      ACCT_ASSIGN_GRP,
      PAY_TERMS_CD,
      SO_SALES_BLOCK_IND,
      NFA,
      RFA,
      TELE1,
      FAX_NBR,
      ACCT_GRP,
      CUST_CLASSIF,
      COMP_POST_BLOCK_IND,
      INDUS_CD1,
      INDUS_CD2,
      INDUS_CD3,
      INDUS_CD4,
      INDUS_CD5,
      PAY_BLOCK_IND,
      CENTRL_SALES_BLOCK,
      DELETE_BLOCK,
      SALES_OFFICE,
      SALES_GROUP

      SQL SELECT *
      FROM
      $(vSchemaName)."VW_R_NAM_CUST_SALES_ORG";


      STORE VW_R_NAM_CUST_SALES_ORG into [$(vToQVD)\VW_R_NAM_CUST_SALES_ORG.qvd] (qvd);

      Drop Table VW_R_NAM_CUST_SALES_ORG;