7 Replies Latest reply: Sep 29, 2015 3:27 PM by Sasidhar Parupudi RSS

    IF THEN Statement to return a value

      I have the following data that I am importing and need to return a certain value in SWEEP_STATUS if the CUST_NBR matches a certain customer, but if it does not match I just want the normal results.  Here is my script and it is telling me garbage after load.  What am I doing wrong?  nd do I have the IF THEN statement in the right place to begin with?

       

       

      LOAD

           COMMITMENT_ID,
           SWEEP_STAT,
          
      CUST_NBR,

      FROM
      [$(vFromQVD)\HRC_LIABILITIES.qvd](
      qvd)

      IF((
      [CUST_NBR] = '0450011670') THEN ([SWEEP_STATUS]='Yes'));

      Store HRC_LIABILITIES_ORIGINAL into  [$(vToQVD)\HRC_LIABILITIES_SWEEP_STATUS_CHANGE.qvd](qvd);