i have concatenated 1 & 2 tables, as they have similar fields , except 1..
Table 1 - Orders
Table 2 - Delivery
Table 1 - Department - example Catering
Table 2 - Dept - example CAT
I need to link these but having an issue
i have left join a Table 3- DepartmentLink
Department - example Catering
DeptCode as Dept - example CAT
is there a way of if CAT is found rename as Catering so a link is made?
Solved! Go to Solution.
Add something like this in the beginning of your data load script:
mapping LOAD * Inline [
And then before the script that loads Delivery table:
Map "Dept" using 'DeptMap';