topic Re: concatenate issue in application in QlikView

concatenate issue in application

sibideepak — Mon, 01 Jun 2015 08:10:20 GMT

Hi all,

I have a table which I used to concatenate to another table ..after reload it shows full table but after saving and reopened the concatenated table is lost ..no data regarding to that table is available...

can anyone help regarding this issue ..!!

Thanks in advance !!

Re: concatenate issue in application

alexandros17 — Mon, 01 Jun 2015 08:11:40 GMT

Can you share the piece of script?

Re: concatenate issue in application

sibideepak — Mon, 01 Jun 2015 08:42:01 GMT

NoConcatenate

LOAD *

,Key as Key1

Resident A;

DROP Table A;

Concatenate(B)

LOAD Key,

Value1,

Value2

FROM

[Temp.qvd] (qvd) Where not Exists(Key1,Key);

this is the logic I applied ... it works sometimes but troubles many times ..how the work logic changes randomly i'm confused !!

Re: concatenate issue in application

alexandros17 — Mon, 01 Jun 2015 08:51:17 GMT

Change the script in this way and tell me what is changed:

NoConcatenate

LOAD *

,Key as Key1

Resident A;

DROP Table A;

NoConcatenate

LOAD Key,

Value1,

Value2

FROM

[Temp.qvd] (qvd) Where not Exists(Key1,Key);

Final:

Noconcatenate

Load * resident B;

concatenate

Load * resident C;

drop tables B, C;

Re: concatenate issue in application

timanshu — Mon, 01 Jun 2015 10:57:00 GMT

what is the table A?