Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Could you explain about island table ?
need set analysis
Thanks & regards,
Siva ramakrishna
Island table is a table that is not connected to any other table in the data model.
could you explain with examples ?
As TB Said, Which island table is UN-associated table.
As Example
T1:
Load * T1;
NoConcatenate
T2:
Load * T2;
And then check DM by using Ctrl + T (Here, You may check those two directories are assiciative or not)
The Table which is not connected with any other table in Qlikview data modeling,That will call it as a...data island,
Suppose,
if we have a..some tables(dimension tables)..surrounded with order table(fact table) as like below,
from this...,
soap details table and city tables are connected with orders table....means...these tables are having relationship with order table.
but region table is not connected with any of the table.because it don't have any link filed to connect with any other tables.
here region table is the island
Hi Siva,
As you can see from following tables where you can not see any common key and if same you will add in big data model and one of this table will not have common key then this table will be considered as island table.
Example:-
t1:
MINValue | MAXValue | Identifier |
0 | 0.012 | 0 |
0.012 | 0.0347 | 1 |
0.0347 | 0.1096 | 2 |
0.1096 | 0.3034 | 3 |
0.3034 | 0.6301 | 4 |
0.6301 | 1.5115 | 5 |
1.5115 | 3.4873 | 6 |
3.4873 | 12.9616 | 7 |
12.9616 | 101 | 8 |
t2:
value | Monthnames |
0 | Jan-16 |
0.01 | Feb-16 |
0.05 | Mar-16 |
0.1 | Apr-16 |
0.1 | May-16 |
0.75 | Jun-16 |
0.2 | Jul-16 |
10 | Aug-16 |
10.5 | Sep-16 |
5.5 | Nov-16 |
50 | Dec-15 |
50.5 | Nov-15 |
3.7 | Oct-15 |
0.013 | Mar-15 |
0.01094 | Feb-15 |
1 | Jan-15 Thanks, |
Thanks,
So say you have to join the Island Table to the Fact Table, how would you accomplish it. Thank you.
It will be an auto crossjoin, exploding in nature.