Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
Partner - Creator III
Partner - Creator III

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

How to get answers to your post?

QlikView Qlik Sense consultant
soniasweety
Master
Master
Author

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
Partner - Creator III
Partner - Creator III

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,

QlikView Qlik Sense consultant
vishsaggi
Champion III
Champion III

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

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

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
Creator
Creator

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.