topic Re: hi in QlikView

hi

Fri, 21 Nov 2014 06:28:09 GMT

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

Re: hi

vardhancse — Fri, 21 Nov 2014 06:35:21 GMT

correct

Re: hi

amit_saini — Fri, 21 Nov 2014 06:40:01 GMT

Madhu,

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

Understanding Join, Keep and Concatenate

Thanks,

Re: hi

sujeetsingh — Fri, 21 Nov 2014 06:41:53 GMT

It seems ok .

Re: hi

Anonymous — Fri, 21 Nov 2014 06:45:49 GMT

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

Re: hi

SunilChauhan — Fri, 21 Nov 2014 06:56:37 GMT

not correct

TableNames should be like

[Table A]: and [Table B]:

as qlikview givers error when space in name of table

Re: hi

Fri, 21 Nov 2014 07:16:13 GMT

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

Re: hi

Anonymous — Fri, 21 Nov 2014 07:38:00 GMT

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

Re: hi

SunilChauhan — Fri, 21 Nov 2014 08:14:40 GMT

better to use like below

[Table A]:

Load * inline [

field here

[Table B]:

Concatenate

Load * inline [

field here