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/ScriptRegu...
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 :
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/47516i8CC958E5AEC83B05/image-size/large?v=v2&px=999)
Sounds cool, let's go further and build a table :
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/47517iD1789E4317E55FB5/image-size/large?v=v2&px=999)
Sooooooo, basically, next step, I should only show the value in TableA.
Wait for it....
![simonaubert_0-1611173337340.png simonaubert_0-1611173337340.png](https://community.qlik.com/t5/image/serverpage/image-id/47518iEF690BD9178DC57D/image-size/medium?v=v2&px=400)
Really ? Why do I have the value 3?
Well, let's have an aggregation now :
![simonaubert_2-1611173565848.png simonaubert_2-1611173565848.png](https://community.qlik.com/t5/image/serverpage/image-id/47520i4D3FEDBFEFB428E2/image-size/medium?v=v2&px=400)
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;
![simonaubert_3-1611173710431.png simonaubert_3-1611173710431.png](https://community.qlik.com/t5/image/serverpage/image-id/47521i16811DD624D533E8/image-size/medium?v=v2&px=400)
Same result :
![simonaubert_5-1611173839322.png simonaubert_5-1611173839322.png](https://community.qlik.com/t5/image/serverpage/image-id/47523i8CA2F6F2038A51C7/image-dimensions/739x226?v=v2)
And finally... what if I want the value of TableB ?
![simonaubert_6-1611173925898.png simonaubert_6-1611173925898.png](https://community.qlik.com/t5/image/serverpage/image-id/47524i588F9A690B5A304D/image-size/medium?v=v2&px=400)
![simonaubert_7-1611173988946.png simonaubert_7-1611173988946.png](https://community.qlik.com/t5/image/serverpage/image-id/47525iAF37F0268132CDED/image-size/medium?v=v2&px=400)
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.
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/47526iF740E6F9CC2FB8E9/image-size/large?v=v2&px=999)
(sorry for the meme, it's my way to relax)
Best regards,
Simon
Bi Consultant (Dataviz & Dataprep) @ Business & Decision