Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
sorry but you need to provide more details about your requirement.
How to get answers to your post?
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;
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;
regards,
If three tables are not in relation then the data model will have Island tables. So What exactly is your requirement? Can you elaborate?
Hi Sony,
Without a relationship between the table, it's not possible to make a data model.
it's my personal opinion.
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
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.