Merging Tables

[paulwalker]

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

[paulwalker]

anybody is  there please help me....

[MayilVahanan]

Hi

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.

[MK_QSL]

Left Join (Table1)

Load DOCID, Item, Material resident Table2;

[paulwalker]

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

[MayilVahanan]

Hi

Try like this

Concatenate or left join

[#7]

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

[angelaecheverri]

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

[#9]

Hola, esta página tiene ejemplos.

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

Saludos.