Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think in this regard the preceding needs to be considered as a single load.
- Marcus