Linking Fields

[joeybird]

Hi

have issue

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?

please help

[maxgro · Accepted solution]

do you want to change the value of a field when the value is CAT?

if yes

load

     ......,

     if(originalfield='CAT', 'Catering', originalfield) as originalfield

     ....

[reddy-s]

Hi Joanna,

Can you attach a sample file so that it would be easy to figure the issue and solve it?

[#4]

Have seen something about "ApplyMap" - perhaps this would be helpful?

Afraid I haven't used it before though!

[alextimofeyev]

Add something like this in the beginning of your data load script:

DeptMap:

mapping LOAD * Inline [

OldValue,NewValue

CAT,Catering

SMTH,Something Else];

And then before the script that loads Delivery table:

Map "Dept" using 'DeptMap';

[joeybird]

This worked brill but had to make small amendment

if(Dept='CAT', 'Catering', Dept) as Department

thanx team

Kind Regards