Please subscribe on my YouTube Channel.
How to Capture Previous value using variable
You can store previous record values by creating variable ports in the expression transformation.
By doing this you can compare previous record values with current record values
The important thing to understand is that values in an expression transformation are retained across rows and that the expressions are evaluated in order from top to bottom
----------------------Documentation------------------------------
The Integration Service evaluates ports in the following order:
Input ports. The Integration Service evaluates all input ports first since they do not depend on any other ports. Therefore, you can create input ports in any order. Since they do not reference other ports, the Integration Service does not order input ports.
Variable ports. Variable ports can reference input ports and variable ports, but not output ports. Because variable ports can reference input ports, the Integration Service evaluates variable ports after input ports. Likewise, since variables can reference other variables, the display order for variable ports is the same as the order in which the Integration Service evaluates each variable.
For example, if you calculate the original value of a building and then adjust for depreciation, you might create the original value calculation as a variable port. This variable port needs to appear before the port that adjusts for depreciation.
Output ports. Because output ports can reference input ports and variable ports, the Integration Service evaluates output ports last. The display order for output ports does not matter since output ports cannot reference other output ports. Be sure output ports display at the bottom of the list of ports.
