...
In this exercise you will build a history with "sparse" data – that is, data for which, in each new data set, there is a record for only a small portion of the key values.
Files containing billing reports can be found in the input files, in the directory:
…\inputData\input\BillingReports
Each file contains the results from a billing run – and in each billing run, only a small portion of the overall set of accounts is billed.
You will read in a copy of these files on the CenterView PhixFlow server, and use the data to build a view of all billing activity across all accounts:
...
This expression will add the value from the previous "active" record for the current key value to the new value being read in for this key value
CenterView PhixFlow will then mark the previous "active" record as superceded (by setting the Superceded Date to the current date and time)
Since the new record for this key value has a blank Superceded Date, this becomes the new "active" record for this key value
...