three different source

[soniasweety]

Hi All,

HIC

I have data from three different datatables  and there is no relationship between 3tables   so which is the best way to build the data model?

example:

Data:

LOAD *, 'Source1' as Source FROM source1;

LOAD *, 'Source2' as Source FROM source2;

LOAD *, 'Source3' as Source FROM source3;

can anyone suggest the best way ?   any sample examples is highly appreciated

Thanks

Sony

[kfoudhaily]

sorry but you need to provide more details about your requirement.

How to get answers to your post?

[soniasweety]

thanks

for example below is my data  there is no relation ship in the three tables so how can I build datamodel ? can you assist ?

source1 :

load *

A

B

C

from...source1

Source2:

load *

D

E

F

from  source2

source3:

load *

g

H

I

from source3;

[kfoudhaily]

your question is too vague;

if no logical relationship between the tables no data model can be created from your data.

but if, let say, A is the same as D, you can do this;

source1 :

load *

A,

B,

C

from...source1

Source2:

load *

D as A,

E,

F

from  source2...

creating data model question cannot be answered without context.

please refer to qlik help for more info, else you can provide sample data;

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/LoadData/best-practices-...

regards,

[vishsaggi]

If three tables are not in relation then the data model will have Island tables. So What exactly is your requirement? Can you elaborate?

[pintucs20]

Hi Sony,

Without a relationship between the table, it's not possible to make a data model.

it's my personal opinion.

[pooja_prabhu_n]

Hi,

you can try doing concatenate .

source1 :

load *

'Source1' as Flag,

A,

B,

C,

' ' as D,

' ' as E,

' ' as F,

' ' as g,

' ' as H,

' ' as I

from...source1;

Source2:

concatenate

load *

'Source2' as Flag,

' ' as A,

' ' as B,

' ' as C,

D,

E,

F,

' ' as g,

' ' as H,

' ' as I

from  source2

source3:

concatenate

load *

'Source3' as Flag,

' ' as A,

' ' as B,

' ' as C,

' ' as D,

' ' as E,

' ' as F,

g,

H,

I

from source3;

Thanks,

Pooja

[thevingo]

Hi

My opinion is

1. you may not require to do further data modeling(Island).

2. Is there a requirement like shared filters then you've to link tables based on the requirement.

3. At most you can concatenate all tables into one which is not recommended.