Storing Multiple table fields into one table

[Anonymous]

Hi all,

Consider i have 3 tables.

Table 1: with 3 columns

A

B

C

Table 2: with 4 columns

A

D

E

F

Table 3: with 3 columns

D

H

I

Data model for above tables:

I need to make an association with these 3 tables with common fields, and to store all the columns into one single table as below

Sorry. i forgot something. Please tell me how can i achieve this, without using JOINS..

[kumarkp412]

Hi Kishore ,

Based on my understand,

use the join commad to aload the all the coloumns in one table.The below is the syntax.

i.e

Table1:

load

A,B,C

from table1;

left join(Table1)

Load

A,D,E,F

from table2;

left join(Table1)

Load

D,H,I

from table3;

[ramasaisaksoft]

Hi Kishore,

y don't we use concatenate ?

[marcus_sommer]

One way would be to merge these tables like suggested from kumarkp412 whereby you might need to combine joining, mapping and concatenating to create a correct table.

Another approach could be this one Storing a Data Model in a Single QVD | Qlikview Cookbook‌.

- Marcus

[Anonymous]

Sorry. i forgot something. Please tell me how can i achieve this, without using JOINS..

[Anonymous]

Sorry. i forgot something. Please tell me how can i achieve this, without using JOINS..

[kumarkp412]

Hi Kishore,

can you provide us some more information on your data .

Thanks

Kumar

[satheshreddy]

hi,

we can achieve either joins are concatenate.

this tables Better to use joins,

why you are asking except joins?

Regards

Sathish