2 Replies Latest reply: Oct 13, 2016 11:09 AM by gidon david RSS

    nulls in ERD

    gidon david

      hi guys

       

      I need to replace all null values in my ERD  as ZERO

       

      enclosed in a sample of my documents  .

      there are some NULL values that I want to replace

      can it be done ?

       

      thanks

      gidon

        • Re: nulls in ERD
          Sunny Talwar

          You can try this:

           

          part:

          LOAD * INLINE [

              part

              100

              200

              300

              400

          ];

           

          vol1:

          LOAD * INLINE [

              part, vol1

              100, 5

              200, 4

              400, 3

          ];

           

          vol2:

          LOAD * INLINE [

              part, vol2

              200, 13

              300, 15

          ];

           

          Left Join (part) LOAD * Resident vol1 ; drop Table vol1 ;

           

          Left Join (part) LOAD * Resident vol2 ; drop Table vol2 ;

           

          NULLASVALUE *;

          SET NullValue = 'ZERO';

           

          FinalTable:

          NoConcatenate

          LOAD *

          Resident part;

          DROP Table part;