Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Replace Load with Concatenate

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

];

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Replace Load with Concatenate

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.

4 Replies

Re: Replace Load with Concatenate

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?


talk is cheap, supply exceeds demand
Not applicable

Re: Replace Load with Concatenate

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

Re: Replace Load with Concatenate

Use ADD for the second load instead of REPLACE


talk is cheap, supply exceeds demand
MVP
MVP

Re: Replace Load with Concatenate

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.

Community Browser