10 Replies Latest reply: Feb 2, 2016 5:05 PM by Marco Wedel RSS

    how to replace null values with out using resident load

    siva reddy

      hi,

       

      i have 2 tables

      one is master table contains two fields (%BILLINGDOC,sysfillener )two columns,

      Another one is vendor table which contains two fields(%SYSLIFNR ,NAME1) , after i joining to tables based on the key column i am get null values in in that place i want replace with 'other_vendor',

       

      My Script is

      LOAD

      %BILLINGDOC,

             %SYSLIFNR

      FROM

      [L:\2Integration\QVD\Invoicing\PoC-US\BILLING_2years_BA-US.qvd]

      (qvd);

      left join

      LOAD

      %SYSLIFNR,

      NAME1

      FROM

      [L:\2Integration\QVD\Master data\LFA1-US.qvd]

      (qvd);

       

       

      My output will be like this:

       

      Header 1Header 2Header 3
      %SYSLIFNR%BILLINGDOC, NAME1
      US65416823276-
      us34665890670-
      us56874474987-
      us74084698396-
      us73749840865-
      us95476879878-
      uk45676909889-
      us43569078988-
      us47987289808vwr
      uk53874792389ios
      gd46984750070-
      us52783479739-
      uk38746749801skk

       

      i want  replace null values with 'other_vendor',with out using resident load for master table and apply map also.

       

      Can any one help me on that..

       

      Thanks in advance.

       

      regards

      siva reddy