topic Re: Linking Fields in App Development

Linking Fields

joeybird — Wed, 18 Nov 2015 19:35:15 GMT

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 — Wed, 18 Nov 2015 19:40:13 GMT

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 — Wed, 18 Nov 2015 20:43:08 GMT

Hi Joanna,

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

Thu, 19 Nov 2015 08:59:05 GMT

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

Afraid I haven't used it before though!

alextimofeyev — Thu, 19 Nov 2015 11:47:43 GMT

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 — Thu, 19 Nov 2015 15:30:35 GMT

This worked brill but had to make small amendment

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

thanx team

Kind Regards