how to replace null values with out using resident load

[Anonymous]

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

(qvd);

left join

LOAD

%SYSLIFNR,

NAME1

FROM

(qvd);

My output will be like this:

Header 1	Header 2	Header 3
%SYSLIFNR	%BILLINGDOC,	NAME1
US	65416823276	-
us	34665890670	-
us	56874474987	-
us	74084698396	-
us	73749840865	-
us	95476879878	-
uk	45676909889	-
us	43569078988	-
us	47987289808	vwr
uk	53874792389	ios
gd	46984750070	-
us	52783479739	-
uk	38746749801	skk

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

[MarcoWedel]

Hi,

if you are that concerned about your loading performance you could as well forget about the joining bit and use Hirish's solution in the front end:

table1:
LOAD * INLINE [
    %SYSLIFNR, %BILLINGDOC
    US, 65416823276
    us, 34665890670
    us, 56874474987
    us, 74084698396
    us, 73749840865
    us, 95476879878
    uk, 45676909889
    us, 43569078988
    us, 47987289808
    uk, 53874792389
    gd, 46984750070
    us, 52783479739
    uk, 38746749801
];

table2:
LOAD * INLINE [
    %BILLINGDOC, NAME1
    47987289808, vwr
    53874792389, ios
    38746749801, skk
];

hope this helps

regards

Marco