i need few diff plz

Wed, 24 Jun 2015 05:20:42 GMT

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

Re: i need few diff plz

Chanty4u — Wed, 24 Jun 2015 07:43:01 GMT

Hi,

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:

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

Thanks

Suresh