topic Forced concatenation in QlikView

Forced concatenation

vikasmahajan — Wed, 24 Jul 2013 04:52:03 GMT

Dear All

Can any one have force concatenation qvw demo and what is that ?

Thanks

Vikas

Re: Forced concatenation

tresB — Wed, 24 Jul 2013 05:09:01 GMT

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.

PFA

Re: Forced concatenation

er_mohit — Wed, 24 Jul 2013 05:24:22 GMT

Concatenation

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:

original tab1

col_a	col_b	col_c
jhkjhkhkj	jjkjjk	green
hhih89hyoh	bhbb	red

second load

col_c	col_x	col_y
black	kjlkjlj	vjvjh
white	bbkbb	bblii
red	dfyyf	vbkh

the concatenated tab1 will look like:

tab1

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

Re: Forced concatenation

Wed, 15 Apr 2015 16:44:00 GMT

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