concatenate issue in application

[sibideepak]

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 !!

[alexandros17]

Can you share the piece of script?

[sibideepak]

B:

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 !!

[alexandros17]

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

B:

NoConcatenate

LOAD *

,Key as Key1

Resident A;

DROP Table A;

C:

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;

[timanshu]

what is the table A?