Joining Tables

[ValeriaBonini]

Hi, I have 2 tables like that:

Table1: 

Load KeyNumber

         ,region

        ,price

From ...

LEFT KEEP(Table1)

Table2:

Load KeyNumber

           ,description

          ,Area

From ....

But like this I have some KeyNumbers in Table1 that aren't in Table2, so there is no Area assigned

How can I put the white values in an Area called "Other"?

[Kushal_Chawda]

You need to perform a join instead keep to fill the null values. Then you can have several ways to fill the null values. 

Table1: 

Load KeyNumber

         ,region

        ,price

From ...

LEFT join(Table1)

Table2:

Load KeyNumber

           ,description

          ,Area

From ....

map_null:

mapping Load null() as Null,

                             'Others' as Value

autogenerate 1;

map Area using map_null;

Final:

noconcatenate LOAD *

resident Table1;

drop table Table1;