applymap...help plssss

[#1]

Hi Experts,

i have the following script.

MapTable:

Mapping LOAD * INLINE [

    OLD,  NEW

    0831,  0201

    0208,  0214

    0210,  0212

];

Branch:

LOAD

    Applymap('MapTable', BRCODE, BRCODE) as BRCODE,

    BRNAME,

FROM

QVD\BRANCH.qvd

(qvd);

Calls:

LOAD  Applymap('MapTable', BRCODE, BRCODE) as BRCODE ,

    Date,

    BRNAME,

    Answered

FROM

QVD\DATA.qvd

(qvd);

concatenate

LOAD Date,

    BRNAME,

    Lookup('BRCODE','BRNAME', BRNAME,'Calls')  as BRCODE,

     Answered

FROM

QVD\CallDetails.qvd

(qvd)

Sales:

LOAD  Date,

      Amount,

    Applymap('MapTable', BRCODE, BRCODE) as BRCODE

FROM

QVD\Sales.qvd

(qvd);

I want to do mapping on BRCODE for all the above tables.

the applymap does works on all tables except Calls table.

the Calls table (after concatenate) doesn't have BRCODE, so i have done a lookup with the other table.

Now, i have to use applymap for Calls table (after concatenate).

How can i do this...pls help....

[#2]

anybody help plsss

[hic]

You need to change the definition of BRCODE also in this table. The test is to precede it with 'X' everywhere. You haven't done that in the concatenated part of the Calls table. You should use

     'X' & Lookup('BRCODE','BRNAME', BRNAME,'Calls')  as BRCODE,

Further, the 'X' is not a solution - it is just a tool that (hopefully) makes the problem visible.

HIC

[#4]

no henric,

its not working

pls give some other suggestions for that concatenate part

[hic]

It's impossible to tell what's wrong without the data.

HIC