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?