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

Partial Reload and Concatenation

Hi,

I need to partially reload two tables and concatenate them. Is this possible in qlikview?

During partial reload, will it execute the concatenate key word?

Thanks!!

6 Replies
Not applicable
Author

Thanks DV! I wil have a look at that video.

Keep up the good work!

Carter

IAMDV
Luminary Alumni
Luminary Alumni

You are welcome mate! Thanks for the encouragement. Where are you based?

Cheers - DV

Not applicable
Author

Hi DV,

The video is very good to understand partial load.

My scenario is:

add Load A,B,C

from table1

Concatenate

add Load D,E,F

from table2

Can i execute the above statements in partial reload?

My doubt is during partial reload whether the Concatenate keyword will be executed??

IAMDV
Luminary Alumni
Luminary Alumni

Hi,

Yes, it's possible to execute Concatenate and other QV commands in Partial Reload. You need to use IsPartialReload Function to execute Exit Script command. I'm quickly pasting the sample code and I'm going to include this task in the second part of video tutorial, I hope it's okay you? Please try to change the below code according to your requirement and if you are still having issues then please wait for video tutorial or demo.

Directory;

Employees:

LOAD EmployeeKey,

     FirstName,

     LastName

FROM

[Support Files\Employee.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate (Employees)

ADD ONLY LOAD Empkey AS EmployeeKey,

     Fname AS FirstName,

     Lname AS LastName,

     Dep

FROM

[Support Files\NewEmployees.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

if IsPartialReload = -1 Then

EXIT Script;

ENDIF

Thanks,

DV

IAMDV
Luminary Alumni
Luminary Alumni

Have you managed to get this working? I have created a demo and I'll post the same sometime soon.

IAMDV
Luminary Alumni
Luminary Alumni

Have you managed to get this working?

Cheers,

DV