topic Re: Storing Multiple table fields into one table in QlikView

Storing Multiple table fields into one table

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

Hi all,

Consider i have 3 tables.

Table 1: with 3 columns

Table 2: with 4 columns

Table 3: with 3 columns

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

Re: Storing Multiple table fields into one table

kumarkp412 — Mon, 02 Jan 2017 13:44:26 GMT

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;

Re: Storing Multiple table fields into one table

ramasaisaksoft — Mon, 02 Jan 2017 13:46:44 GMT

Hi Kishore,

y don't we use concatenate ?

Re: Storing Multiple table fields into one table

marcus_sommer — Mon, 02 Jan 2017 14:04:21 GMT

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

Re: Storing Multiple table fields into one table

Anonymous — Mon, 02 Jan 2017 14:06:31 GMT

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

Re: Storing Multiple table fields into one table

Anonymous — Mon, 02 Jan 2017 14:08:14 GMT

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

Re: Storing Multiple table fields into one table

kumarkp412 — Mon, 02 Jan 2017 14:26:27 GMT

Hi Kishore,

can you provide us some more information on your data .

Thanks

Kumar

Re: Storing Multiple table fields into one table

satheshreddy — Mon, 02 Jan 2017 15:06:03 GMT

hi,

we can achieve either joins are concatenate.

this tables Better to use joins,

why you are asking except joins?

Regards

Sathish