idea Re: Real Loosen Tables - Status changed to: Open - Collecting Feedback in Suggest an Idea

Real Loosen Tables

simonaubert — Wed, 20 Jan 2021 20:25:31 GMT

Hello all,

I work on a project where I try to offer to the user an access to some dozens of table. Of course, in order to prevent bad joining or lnking, I have to break the relation between tables. I have, as far know, two options for that : qualify or loosen table. If you're not familiar with it : a loosen table is a table without any link to the other table.
https://help.qlik.com/fr-FR/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/loosen-table.htm

So, let's test :

TABLEA: LOAD * Inline [FIELD_A, FIELD_B, FIELD_C VALUEA1,VALUEB1,100 VALUEA2,VALUEB2,200] ; loosen table TABLEA; NoConcatenate TABLEB: LOAD * Inline [FIELD_A, FIELD_D, FIELD_C VALUEA1,VALUEB1,100 VALUEA3,VALUEB2,200] ; loosen table TABLEB;

Result :

Sounds cool, let's go further and build a table :

Sooooooo, basically, next step, I should only show the value in TableA.
Wait for it....

Really ? Why do I have the value 3?

Well, let's have an aggregation now :

Ok, this time, it's what I expected.

I will now make this game a little harder : what if the two tales have the exact same field name?

TABLEA: LOAD * Inline [FIELD_A, FIELD_B, FIELD_C VALUEA1,VALUEB1,100 VALUEA2,VALUEB2,200] ; loosen table TABLEA; NoConcatenate TABLEB: LOAD * Inline [FIELD_A, FIELD_B, FIELD_C VALUEA1,VALUEB1,100 VALUEA3,VALUEB2,200] ; loosen table TABLEB;

Same result :

And finally... what if I want the value of TableB ?

I' m unable to query the second table...

But I may have misunderstood loosen for lost 🤡

Well, finally, the idea is simply to have a naturel management of loosen table, a real independancy and the ability to query all the data.

(sorry for the meme, it's my way to relax)
Best regards,

Simon

Re: Real Loosen Tables

Meghann_MacDonald — Wed, 27 Jan 2021 22:11:16 GMT

This looks like a tough one!

Re: Real Loosen Tables

simonaubert — Wed, 27 Jan 2021 22:32:41 GMT

@Meghann_MacDonald Probably not the easiest idea I posted but the behaviour today... who does understand the logic and use it?

At Tableau, for the new "relation" feature, they add a layer of modelisation, I guess something like that would make it for the loosen table?

Re: Real Loosen Tables

Olivier_W — Fri, 19 Feb 2021 15:01:14 GMT

I agree Meghann

Re: Real Loosen Tables - Status changed to: Open - Collecting Feedback

Ian_Crosland — Wed, 07 Dec 2022 12:08:39 GMT

Re: Real Loosen Tables

fbar — Wed, 19 Apr 2023 11:17:06 GMT

Your solution is basically what Qualify does, right?

But I too would like to have Joins like in SQL.
Right now, Tables are joined by Fieldnames.

But SQL Joins are MUCH better.

Re: Real Loosen Tables

simonaubert — Wed, 19 Apr 2023 11:53:28 GMT

@fbar Hello. More than a solution, it's an idea request (and you can vote for 😉 ). qualify would add a prefix to the field name and I don't want that prefix.

Best regards,

Simon

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

Meghann_MacDonald — Wed, 02 Aug 2023 16:14:40 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: Real Loosen Tables - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 16:14:43 GMT