topic Need help to avoid creating duplicate tables in QlikView

Need help to avoid creating duplicate tables

Anonymous — Fri, 25 Mar 2011 15:21:03 GMT

I am a new developer and looking for options.

Here is my scenario

1. We have transaction table and each transaction is owned by user. each transaction can have multiple activities and activities owners could be same as Transaction owner or different.

Here is some data

User table

userid	uname
1	test1
2	test2
3	test3
4	test4
5	test5

Transaction data

TranId	TranOwnerId = userid
Tr1	1
Tr2	3
Tr3	4

Activity data

Actid	TranId	ActuserId = userid
Act1	Tr1	1
Act2	Tr1	2
Act3	Tr1	3
Act4	Tr2	2
Act5	Tr2	3
Act6	Tr2	4
Act7	Tr3	3
Act8	Tr3	4
Act9	Tr3	5

I can create transactionuser table as well as activityuser table. but we have many more such scenarios and I will end up creating 5-6 user tables.

Is there any way..

Thanks

Vaibhav

Need help to avoid creating duplicate tables

pover — Sat, 26 Mar 2011 18:41:32 GMT

I'm not sure I understand. You have different versions of your user tables? Can you concatenate all the user tables into one table?

Regards.

Need help to avoid creating duplicate tables

Anonymous — Mon, 28 Mar 2011 13:38:48 GMT

No I have only one user table and transaction and activity table is referencing to same one.

Only option I have is creating duplicate user table and referencing separately to Tran and activity table. Now we have another table Task which has 1:M relationship with Activity table and referring to the same user table. In this case I need to create another duplicate table for user and relate to task table.

Thanks