Linking table without circular creation

[priya2]

Hi,

I need to link below tables without creating circular formation.

In table 1: i have sno,name and date fields.

In table 2: No,Name,Course,DOJ.

In table 3 :  No2  and Amt.

first I should link the table 1 and table 2 using Name column to get the Course and other values from table 2.

Also the link i should make between Table 1 and Table 3 using No column & Table 2 and Table 3 using No Column to get the Amt from Table 3.

Please help in achieving this.

Table 1:

Table 1
Sno	Name	Date
1	John	1/5/2019
2	Ram	2/5/2019
3	Syed	3/5/2019
4	Arun	4/5/2019

Table 2:

No	Name	Course	DOJ
1	John	BCA	1/5/2019
2	Ram	Bsc	2/5/2019
3	Syed	Msc	3/5/2019
4	Jai	Commerce	4/5/2019
5	Raj	BCA	4/5/2019

Table 3:

No2	Amt
1	1000
2	2000
3	3000
5	4000

[Claudiu_Anghelescu]

Table1: Sno, Name, Date
Table2: No, Name, Course, DOJ
Table3: No, Amt

[Brett_Bleess]

Just wanted to add the following as some further explanation as to why Claudiu's solution should work:

https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

That is a Design Blob post from Henric Cronstrom explaining circular references and how to deal with them, so if Claudiu's post left you with any further questions, hopefully the above link will take care of those for you.

Decided to add one more as well, this one is regarding synthetic keys:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Regards,
Brett