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

[swuehl]

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

That's what I had in mind, using a MAPPING approach. Why do you don't want to consider this?

[Anonymous]

Maybe use NullAsValue

SET NullValue = 'other_vendor';

NullAsValue  NAME1 ;

..... your script

NullAsNull  NAME1 ;

[HirisH_V7]

Hi,

For field,

If(isnull(Header 3),'Other_Vendor',Header 3) as Header 3

Hope this helps,

Hirish

[swuehl]

I still would favour ApplyMap():

Don't join - use Applymap instead

[Anonymous]

With apply map, performance is very low. That's why I avoid apply map. Is there any other way to replace null values?

Thanks

[Anonymous]

hi

its working but i want to use without resident load of master table.

[Anonymous]

I find ApplyMap() high performance.

But when loading from a qvd it will only be a fast optimised load if there is no data manipulation except a single WHERE EXISTS.

So as an ApplyMap()  manipulates data this a non optimised load could be the low performance you have seen.

Why not put the ApplyMap() in the qvd generator and only generate a single qvd ?

[Anonymous]

yes that's correct,

but my requirement is not 2 fields in master table i have 500+ columns, if i use apply map or resident load for the single filed i that will affect to entire application .

[Anonymous]

Hi Bill,

Thanks for your answer, but i didn't get desired result. if any other ways will be give me that will help a lot.

regards

siva