Pipeline Jinja template expression
Hello, I am looking for a jinga expression/syntax which could help me validate the sum(Field-1) > NN value in a step using if condition.
Below is the pipeline steps:
Table-B structure
Record ID#, country, Qty issued
1, UK, 20.5,
2, UK, 30
3, UK, 30.8
Pipeline
Step-A
When the record is created in table-A
Step-B
Search records in Table-B where b.country = "UK"
If sum(qty) >= 100
Step-C - Create record in Table-C
Else
Step-D - Create record in Table-D
I want the jinga expression to be added in step-B post search is returned to check the sum(qty) and compare if it exceed or equals 100
------------------------------
MC
------------------------------
Below is the pipeline steps:
Table-B structure
Record ID#, country, Qty issued
1, UK, 20.5,
2, UK, 30
3, UK, 30.8
Pipeline
Step-A
When the record is created in table-A
Step-B
Search records in Table-B where b.country = "UK"
If sum(qty) >= 100
Step-C - Create record in Table-C
Else
Step-D - Create record in Table-D
I want the jinga expression to be added in step-B post search is returned to check the sum(qty) and compare if it exceed or equals 100
------------------------------
MC
------------------------------
