idea Automatic generation of Link Table (or presentation with Insight) in Suggest an Idea

Automatic generation of Link Table (or presentation with Insight)

M_Ogimoto — Wed, 25 Nov 2020 08:56:29 GMT

Data models with multiple Fact tables are quite common, and Qlik Sense detects and warns us that Synthetic Keys are being generated at data load time.

If it can detect that much, can't Qlik Sense automatically generate a Link-Table?

Similar to Insight generation in analytics, I think the introduction of Insight to the data model is a necessary feature.

Re: Automatic generation of Link Table (or presentation with Insight)

AndrewMcIlwrick — Mon, 20 Jul 2020 12:51:13 GMT

It could in theory not just generate a link table - that is not always the best solution. Any of the frequent ways to resolve the syn key would be good to have in a new wizard .....

Auto create a composite key
Suggest fields to drop
Analyse suitability for concatenation or join
Etc etc

Also allow a Qualify/Unqualify user preference. The use of qualification in the Data Manager is something I find frustrating !

Re: Automatic generation of Link Table (or presentation with Insight)

M_Ogimoto — Wed, 22 Jul 2020 03:21:00 GMT

@AndrewMcIlwrick Thanks your advice.

I think new wizard to handle the multi-fact table is a nice idea.

Here are my ideas.

Mark the required table as a fact table.
Select the key items in the fact table.
Generate a script to build the linked table.

Then go back to using the Data Manager as normal and load the data.

Any comments or advice would be appreciated.

Re: Automatic generation of Link Table (or presentation with Insight) - Status changed to: Open - Collecting Feedback

Steven_Pressland — Fri, 06 Nov 2020 16:31:26 GMT

Re: Automatic generation of Link Table (or presentation with Insight)

SGV — Tue, 19 Jul 2022 13:41:45 GMT

I was about to post the same idea.. Lol :). This would benefit Business Analysts a lot as they don't want to spend too much time in building a data model.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 16:57:33 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Automatic generation of Link Table (or presentation with Insight) - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 16:57:34 GMT