topic Re: Merging Tables in QlikView

Merging Tables

paulwalker — Wed, 04 Dec 2013 15:44:33 GMT

Hi Community,

I have 2 tables have some fields.

Table1:

(DOCID, start_date, end_date, volume,xyz)

Table2:

DOCID, S_Date,E_Date,Item, Material)

i want merge with

DOCID ------ Table1 Field

Item, Material ------- Table2 Fields

How to merge.....

Re: Merging Tables

paulwalker — Wed, 04 Dec 2013 16:03:57 GMT

anybody is there please help me....

Re: Merging Tables

MayilVahanan — Wed, 04 Dec 2013 16:07:07 GMT

Can you please explain your requirement in detail?

Table1:

Load

* From Table1;

Left join(Table1)

Load * From Table2;

Instead of left join, we can use concatenate, outer join, inner join. Without any join also, qlikview link the table because of common field "DOCID" in both table.

Re: Merging Tables

MK_QSL — Wed, 04 Dec 2013 16:16:29 GMT

Left Join (Table1)

Load DOCID, Item, Material resident Table2;

Re: Merging Tables

paulwalker — Wed, 04 Dec 2013 16:46:29 GMT

thanks for quick reply Mayil,

I am Understanding your example.....

My Requirement is

Suppose i have 2 tables

Table1:

(DOCID, start_date, end_date, volume,xyz)

Table2:

DOCID, S_Date,E_Date,Item, Material)

i want merge with DOCID(table1 field), Item and Material (Table2 fields)

megre with table1 with table2

Re: Merging Tables

MayilVahanan — Wed, 04 Dec 2013 17:15:30 GMT

Try like this

Concatenate or left join

Re: Merging Tables

Wed, 04 Dec 2013 17:30:19 GMT

Concatante ot left join or keep join or inner join you can do

Re: Merging Tables

angelaecheverri — Wed, 04 Dec 2013 18:08:26 GMT

If both tables share same fields QV load data of the first table and then in the same table the data of the second table.

in that way you dont need to do anything...

in your case you just share some of them....

be careful of use concatate, join or keep stament.

each one have a special relationship for each case.

if you let me know more about each table perhaps i could help you to indicate which statement is better in your case...

to link both tables... your script will be something like this:

Table1:

Load

autonumber(DOCID&'-'&start_date&'-'&end_date) as Key.Main,

DOCID as DOCID_Table1,

start_date,

end_date,

volume,

xyz

From

Data.xls

Table2:

Load

autonumber(DOCID&'-'&S_Date&'-'&E_Date) as Key.Main,

DOCID as DOCID_Table2,

S_Date,

E_Date,

Item,

Material

From

Data.xls

Re: Merging Tables

Thu, 05 Dec 2013 01:57:11 GMT

Hola, esta página tiene ejemplos.

www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/

Saludos.