Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"?
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;