Replace Load with Concatenate

[#1]

Hi,

I am trying to concatente 2 tables on a partial reload.

It works when I am doing a full reload, but not the partial.

Tried to put the replace in multiple places, but nothing seems to work.

Attached a sample.

Cheers,

Martin

REPLACE

LOAD * INLINE

[

   Test

   1

   2

   3

];

CONCATENATE

LOAD * INLINE

[

   Test

   4

   5

   6

];

[Gysbert_Wassenaar]

What do you want to do? The values 4,5 and 6 will only be loaded with a full reload. Values 1,2 and 3 will always be loaded. There is nothing to concatenate if you do a partial reload. So what do you want to concatenate?

[#3]

I want to have 1,2,3,4,5,6 when i do a partial reload.

I've tried

REPLACE

LOAD * INLINE

[

   Test

   1

   2

   3

];

CONCATENATE

REPLACE

LOAD * INLINE

[

   Test

   4

   5

   6

];

But that doesn't work. So how to write so i can load and concatenate 2 or more tables when i do a replace load.

Cheers

Martin

[Gysbert_Wassenaar]

Use ADD for the second load instead of REPLACE

[jagan · Accepted solution]

Hi Martin,

Try this script

Test:

REPLACE

LOAD * INLINE

[

   Test

   1

   2

   3

];

ADD CONCATENATE (Test)

LOAD * INLINE

[

   Test

   4

   5

   6

];

Hope this helps you.

Regards,

Jagan.