Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
soniasweety
Valued Contributor III

three different source

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

7 Replies
kfoudhaily
Contributor III

Re: three different source

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

How to get answers to your post?

soniasweety
Valued Contributor III

Re: three different source

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
Contributor III

Re: three different source

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
Esteemed Contributor III

Re: three different source

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
New Contributor III

Re: three different source

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
Contributor III

Re: three different source

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
Contributor

Re: three different source

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.