ALIGN
Syntax
ALIGN(ref_series, series, range)
Parameters
ref_series
series
range
Description
Align a range with position identified by its series to the reference series each row in <range> has a corresponding number, as identified in <series>. The row is aligned to the correct row offset by matching <series> to the offset in <reference_series>. If <series> does not contain the number in <reference_series>, 0 is padded. If <reference_series> does not contain the number in <series>, the row is ignored. If more than 1 row align with the reference series, the first one is used. this is used to align dates, as expressed by numbers, associated with time series starting from different dates. This way, we can generate a block where each row are data from the same day.
Copyright IBM Corporation 2015. All Rights Reserved.
