Please need assistance to remove syn table from Qlikview .

[ashmitp869]

Hi All,

The Market report is working correctly according to the requirement.

But , I want to remove the Syn Table from the Qlikview Script .

Please kindly see the Qlikview Data Diagram .

Sample model attached.

Thanks,

[Anonymous]

Hi,

I haven't looked at the attached model yet.

But looking at the screenshot -

I see the column "market_share_category_name" in table "Deal" is not part of key associated with any other table apart from Synthetic table.

If this is the case, than you can safely remove this column from the Deals table , and the Synthetic key would be removed as well.

[vijetas42]

Please check on which which field you want to join Deal and total_market table.

if you want to join based on single field then you can rename another field from one of the table and if you want to join based on these two then create single key with combination if these two.

or you can use Qualify

[pradosh_thakur]

First thing is are you sure you need to remove the synthetic table? Are both the tables needed to be joined by two keys ? is it slowing down your application or not.

please refer below links.

Should We Stop Worrying and Love the Synthetic Key?‌

Synthetic Keys