Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
anybody is there please help me....
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.
Left Join (Table1)
Load DOCID, Item, Material resident Table2;
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
Hi
Try like this
Concatenate or left join
Concatante ot left join or keep join or inner join you can do
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
Hola, esta página tiene ejemplos.
www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/
Saludos.