topic Partial Reload and Concatenation in QlikView

Partial Reload and Concatenation

Tue, 03 Apr 2012 12:34:34 GMT

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!!

Partial Reload and Concatenation

Tue, 24 Apr 2012 13:55:29 GMT

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

Keep up the good work!

Carter

Re: Partial Reload and Concatenation

IAMDV — Tue, 24 Apr 2012 15:53:34 GMT

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

Cheers - DV

Partial Reload and Concatenation

Wed, 25 Apr 2012 05:52:04 GMT

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

Re: Partial Reload and Concatenation

IAMDV — Wed, 25 Apr 2012 06:37:03 GMT

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,

Re: Partial Reload and Concatenation

IAMDV — Thu, 26 Apr 2012 09:21:05 GMT

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

Re: Partial Reload and Concatenation

IAMDV — Tue, 01 May 2012 17:49:51 GMT

Have you managed to get this working?

Cheers,