Problem With Loop_How Join theese tables

[#1]

Hi All

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

but it has loop in each condition

what should i do?

[Gysbert_Wassenaar]

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.

[#3]

Sorry,How to use mapping table?

[vikasgupta]

Hi

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

[Gysbert_Wassenaar]

//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...;

[sujeetsingh]

You can also go with joins.

[#7]

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