Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
....
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
....
Hi Joanna,
Can you attach a sample file so that it would be easy to figure the issue and solve it?
Have seen something about "ApplyMap" - perhaps this would be helpful?
Afraid I haven't used it before though!
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';
This worked brill but had to make small amendment
if(Dept='CAT', 'Catering', Dept) as Department
thanx team
Kind Regards