topic Re: island Table in QlikView

island Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi Could you explain about island table ?

need set analysis

Thanks & regards,

Siva ramakrishna

Re: island Table

tresB — Wed, 30 Nov 2016 05:14:46 GMT

Island table is a table that is not connected to any other table in the data model.

Re: island Table

Wed, 30 Nov 2016 05:15:29 GMT

could you explain with examples ?

Re: island Table

tresB — Wed, 30 Nov 2016 05:28:07 GMT

Re: island Table

Anil_Babu_Samineni — Wed, 30 Nov 2016 05:32:04 GMT

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)

Re: island Table

Anonymous — Wed, 30 Nov 2016 05:37:42 GMT

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

Re: island Table

Anonymous — Wed, 30 Nov 2016 05:43:15 GMT

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,

Re: island Table

zahra — Mon, 22 Feb 2021 16:24:55 GMT

So say you have to join the Island Table to the Fact Table, how would you accomplish it. Thank you.

Re: island Table

Abir007 — Mon, 23 Aug 2021 09:52:07 GMT

It will be an auto crossjoin, exploding in nature.