topic Problem With Loop_How Join theese tables in QlikView

Problem With Loop_How Join theese tables

Sun, 23 Dec 2012 09:50:24 GMT

Hi All

I Want to join pers_Statistics(T1) and branch_vw(T2)

but it has loop in each condition

what should i do?

Re: Problem With Loop_How Join theese tables

Gysbert_Wassenaar — Sun, 23 Dec 2012 10:42:51 GMT

You could rename the branchcode field in Customers. Or if you don't need the actual branchcode, but the branch_vw.B... field in pers_statistics or Customer you could use a mapping table and applymap to substitute branchcode with the matching branch_vw.B... value.

Re: Problem With Loop_How Join theese tables

Sun, 23 Dec 2012 11:27:40 GMT

Sorry,How to use mapping table?

Re: Problem With Loop_How Join theese tables

vikasgupta — Sun, 23 Dec 2012 12:56:51 GMT

Agree with Gysbert answer but Apply map or mapping table is little bit complex another alternative can be use

qualify*fieldlist function to avoid Circular refernce .

Thanks

Vikas

Re: Problem With Loop_How Join theese tables

Gysbert_Wassenaar — Sun, 23 Dec 2012 18:22:11 GMT

//first load the mapping table

BranchMap:

mapping load

branchcode, branch_vw.B...

from ...somewhere...;

//then use applymap to replace branchcode with branch_vw.B...

Customers:

Load

CustomerCode,

Link_Access,

CustomerType,

applymap('BranchMap',branchcode) as CustomerBranch,

Customers.City,

...etc

from ...somewhere...;

Re: Problem With Loop_How Join theese tables

sujeetsingh — Mon, 24 Dec 2012 06:24:35 GMT

You can also go with joins.

Re: Problem With Loop_How Join theese tables

Mon, 24 Dec 2012 14:46:33 GMT

tnx Gysbert,

but when i create:

BranchMap:

mapping load

branchcode, branch_vw.B...

from branch_vw;

i see error:can not find file of branch_vw.

in the join option : it create sync table