Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikertimea
Contributor
Contributor

Partial load with preceding load statements

Can you use Add/Replace/Merge Load for partial load when preceding loads are used and where do you place the prefix?

Lets say you have the following:

 

Employees:
Load Name,
    rangesum(alt(EmploymentEnd,today()),-EmploymentStart) as ServiceDuration
    ;
Load Name,
    date(EmploymentStart) as EmploymentStart,
    date(EmploymentEnd) as EmploymentEnd
From ...;

 

Do you have to add the Replace prefix to the initial load or do you have to add it to both load statements?

Thanks in advance

Labels (3)
1 Reply
marcus_sommer

I think in this regard the preceding needs to be considered as a single load.

- Marcus