Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Thanks DV! I wil have a look at that video.
Keep up the good work!
Carter
You are welcome mate! Thanks for the encouragement. Where are you based?
Cheers - DV
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??
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
Have you managed to get this working? I have created a demo and I'll post the same sometime soon.
Have you managed to get this working?
Cheers,
DV