Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 

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