s Parameter
The s parameter is the current string representation of a value from a source.
When running rules, this parameter is processed in sequence. It changes for every rule that is run on the data.
Scenario 1: Applied to source 1 only
Let's say you have an initial Quantity value of 5.
Let's say you have some individual rules running a calculation that adds 5 and rounds to nearest 1.
The rule is only applied to source 1
[value from source]
5
5
5
Add 5
5
5
10
Add 5
10
5
15
Round to nearest 1.0
15
5
15.0
The parameter is calculated for each individual source. It is not the result of both
What you would see on-screen:
A cell with a blue border around it, because the final value for both sources are different.
Scenario 2: Applied to both sources
If the rule is turned on for both sources, then the result would be this:
[value from source]
5
5
5
Add 5
5
5
10
Add 5
10
10
15
Round to nearest 1.0
15
15
15.0
What you would see on-screen:
A cell with no border around it, because the final value for both sources are the same.
Import rules only manipulate or use the string value s which is passed to it, for the source that it is enabled for. It does not process the data from both sources, it processes the data for an individual source.
Last updated