Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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