i need few diff plz

[#1]

hello,i need to few diff b/w these

1.diff b/w join and concatenation

when to use join and when to use concatenation in real time

2.diff b/w join and keep

when to use join and when to use concatenation in real time

3.diff b/w join and lookup

when to use join and when to use concatenation in real time

thanks in advance

[Chanty4u]

Hi,

hi

• Diff b/w left keep and left join?

• The join and keep prefixes can be preceded by the prefix left.
• If used before join it specifies that a left join should be used. The resulting table will only contain combinations of field values from the raw data tables with a full set of data from the first table.
• If used before keep, it specifies that the second raw data table should be reduced to its common intersection with the first table, before being stored in QlikView.
• left ( join | keep) [ (tablename ) ](loadstatement |selectstatement )
• Examples:

Table1
A	B
1	Aa
2	Cc
3	Ee

Table2
A	C
1	Xx
4	Yy

• QVTable:
• select * from table1;
• left join select * from table2;

QVTable
A	B	C
1	aa	xx
2	cc
3	ee

• QVTab1:
• select * from Table1;
• QVTab2:
• left keep select * from Table2;

QVTab1
A	B
1	aa
2	cc
3	ee

QVTab2
A	C
1	xx

  The two tables in the keep example are, of course, associated via A.

Thanks

Suresh