Increment variable directive
The INCREMENT-VARIABLE directive increments the value of the variable that is local to the input record being processed.
Syntax
increment-variable variable value exp: {<condition>}The variable is incremented by the value when the <condition> evaluates to true.
Usage Notes
This directive is applied only within the scope of the record being processed. The transient state is reset, once the system starts processing of the new record.
Internally, this directive increments a long value.
Comments
Sep 19, 2022
@Robin Rielley I have 300 record as an input and I am trying to capture total no of records using counter. However it is setting to 1 for every record instead of increment it by 1 till 300.
When I am running same jexl on wrangler studio UI, I can see the desired result but not when running pipeline in preview/deploy mode.
increment-variable v_IN_seq_NEXTVAL 1 true
set-column ANSWER_ID v_IN_seq_NEXTVAL