joining tables

[Anonymous]

The data structure as follows:

MASTER1(ID)

TRAN1(TRANDATE,ID)

TRAN2(TRANDATE,ID)

CALENDAR(TRANDATE,MONTH,YEAR)

I want to establish relationship among these tables.

Points to be considerd:

     1. No relation between TRAN1 AND TRAN2 table.

     2. Both TRAN1 AND TRAN2 table will refer ID in MASTER1 table

please help me out.

[#2]

QlikView uses an associative model.

If you talk about "ID", it's the same "ID" for each table (MASTER, TRAN1 and TRAN2). It's not a different field linked (like in other databases).

If you don't want a link for the TRANDATE field, just rename it.

[#3]

Chandan,

You don't want to join these tables. Create a link table by doing Concatenate load of TRAN1 and TRAN2.

Master:

Load ID,

From Master;

LinkFile:

Load ID,  (This links to the Master

TranDate,  (This links to the calendar

'TRAN1' As RecordType, (Tran1 if you like

Tran1Fact,

From Tran 1;

Concatenate

Load

ID (This links to the Master

TranDate,  (This links to the calendar

'TRAN2' As RecordType, (Tran 2 if you like

Tran2Fact

From Tran2;

[Anonymous]

Thank you for your response.But it is not appropriate in my case because Tran1 and Tran2 table of different structure.

Actually I want to connect both tran tables to Calendar table and Master1 table.

[ToniKautto]

I do not completely follow what you are trying to accomplish with this model, but QlikView is associative so fields with the same names will be linked. Therefore the table will be linked as they share the TRANDATE and ID field.

Please provide a sample QVW loaded with sample data to enable a better understanding of this scenario. If your data is sensitive, please use scrambling funciton to make the fields unreadbale;

Settings > Document Settings > Scrambling