hi

[#1]

when  i use concatenate function the result table will show this type is this correct?

[vardhancse]

correct

[amit_saini]

Madhu,

It is working fine , for more understanding please see link below:

Understanding Join, Keep and Concatenate

Thanks,

AS

[sujeetsingh]

It seems ok .

[Anonymous]

Incorrect.

Remove the space in table name also remove the table 2 as below;

TableA:

Load * inline

[A,B

1,2

3,4];

Concatenate

Load * inline

[c,d

1,2

5,6];

If you want to keep the tables separately before concatenate do as below.

TableA:

Load * inline

[A,B

1,2

3,4];

TableB:

Load * inline

[c,d

1,2

5,6];

ConcattableC:

Load * resident TableA;

concatenate

Load *  resident TableB;

Hope this helps.

BR,

Chinna

[SunilChauhan]

not correct

TableNames should be like

[Table A]: and [Table B]:

as qlikview givers error when space in name of table

[#7]

IF I USE NOCONCATENATE IT ALLOWS SYNTHETIC KEYS AM I WRITE.

[Anonymous]

Hi Madhu,

Synthetic keys doesn't depends on concatenate or no concatenate keywords.

these are created based on the same column names. So you get syntetic keys if same column name exists as below.

TableA:

Load * inline

[A,B

1,2

3,4];

NoConcatenate

TableB:

Load * inline

[A,B

1,2

5,6];

if you reload ..log will show like this.

TableA << INLA5BC 2 lines fetched

TableB << INLA5BD 2 lines fetched

$Syn 1 = A+B

Hope this helps.

Regards,

Chinna

[SunilChauhan]

better to use like below

[Table A]:

Load * inline [

field here

[Table B]:

Concatenate

Load * inline [

field here