Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

];

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

4 Replies
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?


talk is cheap, supply exceeds demand
Not applicable
Author

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


talk is cheap, supply exceeds demand
jagan
Luminary Alumni
Luminary Alumni

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.