Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
Can any one have force concatenation qvw demo and what is that ?
Thanks
Vikas
Forced Concatenation
If two or more tables do not have exactly the same set of fields, it is still possible to force QlikView to concatenate
the two tables. This is done with the concatenate prefix in the script, which concatenates a table
with another named table or with the last previously created table.
Example:
load a, b, c from table1.csv;
concatenate load a, c from table2,csv;
The resulting internal table has the fields a, b and c. The number of records in the resulting table is the sum
of the numbers of records in table 1 and table 2. The value of field b in the records coming from table 2 is
NULL.
tab1:
Load col_a, col_b, col_c from ...;
Concatenate (tab1)
Load col_b, col_x, col_y from ...;
Concatenation adds the records from the load to a previously loaded table (tab1) in the example.
There will be one table (named tab1 in the example) containing all fields from the "original" tab1, and any new fields from the second load,
so assuming two records was in the original tab1, and three new comes fro the second load:
col_a | col_b | col_c |
---|---|---|
jhkjhkhkj | jjkjjk | green |
hhih89hyoh | bhbb | red |
col_c | col_x | col_y |
---|---|---|
black | kjlkjlj | vjvjh |
white | bbkbb | bblii |
red | dfyyf | vbkh |
the concatenated tab1 will look like:
col_a | col_b | col_c | col_x | col_y |
---|---|---|---|---|
jhkjhkhkj | jjkjjk | green | ||
hhih89hyoh | bhbb | red | ||
black | kjlkjlj | vjvjh | ||
white | bbkbb | bblii | ||
red | dfyyf | vbkh |
go to this link
http://www.qlikfix.com/2010/12/09/merging-tables-concatenation/
http://qlikviewnotes.blogspot.in/2009/11/understanding-join-and-concatenate.html
forced concatination is a kind of methodology that we can concatinate two table s though they dont have any field in common............for that we have to rename the field