Data Model Issue in QLiksense

[SunainaUmberkar]

Hello All,

I have an issue wrt to Data Model. I have a Qliksense App, where 6 tables are used. 4 tables are linked with a common column as Userid and other 3 must link with user_transaction field, when I am doing so I am getting a circular reference. 
To avoid circular reference we are aware that we must rename or remove the field but in this  case we cannot do both as the data wont appear properly. Kindly assist how can we resolve this. 

PassportData, User role transaction usage, Sod SUmmary and User Master must be linked with Userid field and User role transaction usage,Sod detailed and Yearly_Trans_Usage must be linked with user_transaction. 

Thanks in advance.

[justISO]

Hi, as I understand from your description, you are linking these tables with only 2 keys, Userid and user_transaction, so maybe field User_Master.key is not needed as a key? in this case just rename it f.e. key2 and loop should disappear - no more link between tables User_Master and SOD_Detailed_New.

[SunainaUmberkar]

Hello JustISo,

Thanks for the reply.

I forgot to mention as I require a link between User_Master and SOD_Detailed_New as well. Hence I have created a Key between this 2. If this is not created my data is not as expected. 

[justISO]

My other suggestion in this case would be to join some tables (if not all) if possible to get rid of links at all. Approach for this is depending on table structures, duplicates existence and so on, but something like this can be as a start maybe:

left join (User_master)
SOD_detailed_new:
load...

[SunainaUmberkar]

Hello justISo,

Thanks. Are you suggesting to remove key and then do a left join with User Master?

I tried to do a left join between SOD_Detailed_new and User role transaction usage table based on user id, but data load time was increased and my app was loading for around an hour, so i aborted it. 

[justISO]

Not remove 'key' as a field, but from two tables, using inner/left join, make only one table, so there will be no relation link between those tables needed. You will remove relation which cause loop (between tables with fields 'key'), but will get synthetic key user_transaction + user ID, which I guess should not brake anything. But I'm starting to guess that in your case this can be a tricky part also, as your tables seems quite big. So already doubting, that my suggestions are good.

[SunainaUmberkar]

Hello,

Thanks for the suggestion. Will try to implement and check. Yes since the table is huge, doing a left join between tables is increasing load time. 

[SunainaUmberkar]

Hello,

Left join/Inner join is not working in this scenario. I tried to concatenate sod_detailed_new and user_master but data in front end has issues. Do we have any other option for this type of scenario. Kindly help. 

Thanks in advance.

[Prashant_Naik20]

Hi,

Try to rename the UserId field of User role transaction usage table. See if that helps.

Regards,

Prashant

[SunainaUmberkar]

Hello Prashant,

That is helping to resolve circular reference, but i require that field as if i remove that link data is not coming properly. I tried all other options as well but nothing is solving my issue. Any suggestions on how to handle this?

Thanks in advance.