Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MP_1
Contributor
Contributor

How to create a link table for 3 three tables

I have 3 tables Customers, Accounts and Transactions.  What is the best way to create a link table between them as I'm not to sure how to go about this with the load script. Hopefully this makes sense. Sample in excel was created

The specific links:

-SourcePartyType = 'C' & SourcePartyID = CustID

-DestPartyType = 'C' & DestPartyID = CustID

  • However if the SourcePartyType ='A' & SourcePartyID = AcctID --> PrimaryAcctID = CustID. Same link for DestPartyType.

 Sometimes a transaction can be made by a combination of the 2. Eg customer made a deposit to an acct 

Any guidance would be great thanks

0 Replies