Left Join Nulls to Zeros

[bazzaonline]

Hello All,

I am joining two sets of data using a left join, the second dataset is small therefore doesn't have the same number of records.  How do I input a 0 where there is no record?  For Example

1 - A

2 - B

3 - C

adding

1 - 1

2 - 2

becomes

1 - A - 1

2 - B - 2

3 - C - Null

I would like

1 - A - 1

2 - B - 2

3 - C - 0

Pleas help

[maxgro · Accepted solution]

use a mapping load with 0 as third parameter in applymap

map:
mapping load * inline [
from,to
1, 1
2, 2
];

t:
load
  f1,
  f2,
  applymap('map', f1, 0) as f3;
load * inline [
f1,f2
1,A
2,B
3,C
];