Good thing is your user table has team ID field. If you can keep same name lets say Team ID in both user table and team table while loading using 'as' keyword, you will have association automatically by virtue of Qlikview association engine. Not much understood from contractor table though. If that needs to be associated, we need some link field with other tables as we have team id common in other tables.
In general, if we don't have primary key or primary key is violating then we can create surrogate key or we can even concatenate two tables and can create a composite primary key to link between tables.
If possible, please share with me the sample data, I will create a small poc and will then share with you.
Good thing is your user table has team ID field. If you can keep same name lets say Team ID in both user table and team table while loading using 'as' keyword, you will have association automatically by virtue of Qlikview association engine. Not much understood from contractor table though. If that needs to be associated, we need some link field with other tables as we have team id common in other tables.
As Sreeni said you to create surrogate key using auto number function in Qlikview and link tables.
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
