topic Re: Replace Load with Concatenate in QlikView

Replace Load with Concatenate

Thu, 07 Mar 2013 14:30:47 GMT

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

];

CONCATENATE

LOAD * INLINE

[

Test

];

Re: Replace Load with Concatenate

Gysbert_Wassenaar — Thu, 07 Mar 2013 14:37:47 GMT

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?

Re: Replace Load with Concatenate

Thu, 07 Mar 2013 14:40:53 GMT

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

I've tried

REPLACE

LOAD * INLINE

[

Test

];

CONCATENATE

REPLACE

LOAD * INLINE

[

Test

];

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

Gysbert_Wassenaar — Thu, 07 Mar 2013 14:44:49 GMT

Use ADD for the second load instead of REPLACE

Re: Replace Load with Concatenate

jagan — Thu, 07 Mar 2013 14:49:37 GMT

Hi Martin,

Try this script

Test:

REPLACE

LOAD * INLINE

[

Test

];

ADD CONCATENATE (Test)

LOAD * INLINE

[

Test

];

Hope this helps you.

Regards,

Jagan.