topic Re: three different source in QlikView

three different source

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: three different source

kfoudhaily — Sat, 28 Jul 2018 20:04:46 GMT

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

How to get answers to your post?

Re: three different source

soniasweety — Sat, 28 Jul 2018 20:09:56 GMT

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 *

from...source1

Source2:

load *

from source2

source3:

load *

from source3;

Re: three different source

kfoudhaily — Sat, 28 Jul 2018 20:15:16 GMT

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 *

from...source1

Source2:

load *

D as A,

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-data-modeling.htm

regards,

Re: three different source

vishsaggi — Sun, 29 Jul 2018 02:17:51 GMT

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

Re: three different source

pintucs20 — Sun, 29 Jul 2018 07:15:14 GMT

Hi Sony,

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

it's my personal opinion.

Re: three different source

pooja_prabhu_n — Mon, 30 Jul 2018 05:18:43 GMT

Hi,

you can try doing concatenate .

source1 :

load *

'Source1' as Flag,

' ' 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,

' ' 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,

from source3;

Thanks,

Pooja

Re: three different source

thevingo — Mon, 30 Jul 2018 05:47:21 GMT

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.