topic Re: assigning values from one table to other in script in QlikView

assigning values from one table to other in script

Fri, 01 May 2015 11:52:48 GMT

Hi Experts,

i have the following tables.

BRANCH:

LOAD BRCODE,

BRNAME as branchname,

BRANCHMANAGER,

RSMNAME

FROM

QVD\BRANCH.qvd

(qvd);

CallDetails:

LOAD DECDDT,

BRNAME as branchname,

Answered,

Unanswered,

Outgoing

FROM

QVD\data.qvd

(qvd);

i have to assign the values of BRCODE( from BRANCH qvd ) to the branchname(in data qvd) in the script itself.(may be like vlookup in excel. the branchname in branch table should look into the branchname in calldetails table and if it got matched, then the BRCODE should get assigned to the branchname in calldetails table)

how can i do that.

please give some suggestions.

its urgent. plsssssssssssssssssssssss.

Re: assigning values from one table to other in script

Gysbert_Wassenaar — Fri, 01 May 2015 11:59:46 GMT

MYMAP:

MAPPING LOAD

BRNAME as branchname,

BRCODE

FROM

QVD\BRANCH.qvd

(qvd);

BRANCH:

LOAD BRCODE,

BRNAME as branchname,

BRANCHMANAGER,

RSMNAME

FROM

QVD\BRANCH.qvd

(qvd);

CallDetails:

LOAD DECDDT,

BRNAME as branchname,

ApplyMap('MYMAP', BRNAME ) as brcode

Answered,

Unanswered,

Outgoing

FROM

QVD\data.qvd

(qvd);

Re: assigning values from one table to other in script

robert_mika — Fri, 01 May 2015 13:02:28 GMT

BRANCH:

LOAD BRCODE,

BRNAME as branchname,

BRANCHMANAGER,

RSMNAME

FROM

QVD\BRANCH.qvd

(qvd);

drop fields branchname,

CallDetails:

LOAD DECDDT,

BRNAME as branchname,

lookup('BRCODE','BRNAME',BRNAME,'BRANCH') as brcode,

Answered,

Unanswered,

Outgoing

FROM

QVD\data.qvd

(qvd);

Re: assigning values from one table to other in script

Fri, 01 May 2015 13:34:12 GMT

hi robert,

it is showing 0 as brcode for all branchnames.

anyother suggestions plsssssssssss

Re: assigning values from one table to other in script

robert_mika — Fri, 01 May 2015 13:45:49 GMT

Did you try Gysbert solution?

Otherwise I may need to see your qwv

Re: assigning values from one table to other in script

Fri, 01 May 2015 13:53:21 GMT

its not working.

it is showing BRNAME values in brcode field which is wrong.

BRCODE is a numeric value. its the branch code for different branch names.

i want the BRCODE values from branch table to get added to the calldetails table's branchnames.

for ex.

in branch table, i have

BRCODE branchname

0001 london

0002 swindon

0003 Newbury

and so on

in call details table, i have

branchname date answered unanswered

newbury 01/01/2015 10 2

london 02/03/2015 5 0

i have to assign the BRCODE as a new field with the branchname in calldetails table.

please give suggestions.

its very urgent plssssssssssssss

Re: assigning values from one table to other in script

Fri, 01 May 2015 14:14:18 GMT

anybody help plssssssssss

Re: assigning values from one table to other in script

MarcoWedel — Fri, 01 May 2015 16:11:46 GMT

please post sample data, otherwise it will be difficult to find your issues...

regards

Marco

Re: assigning values from one table to other in script

ramoncova06 — Fri, 01 May 2015 17:36:07 GMT

if your data is identical to the example you posted here then the issue is most likely with the cases not matching

just added the upper() function to your fields and that should do, here is gwassenaar‌code updated with the upper

MYMAP:

MAPPING LOAD

upper(BRNAME) as branchname,

BRCODE

FROM

QVD\BRANCH.qvd

(qvd);

BRANCH:

LOAD BRCODE,

BRNAME as branchname,

BRANCHMANAGER,

RSMNAME

FROM

QVD\BRANCH.qvd

(qvd);

CallDetails:

LOAD DECDDT,

BRNAME as branchname,

ApplyMap('MYMAP', upper(BRNAME) ) as brcode

Answered,

Unanswered,

Outgoing

FROM

QVD\data.qvd

(qvd);