Upsert based on Condition
Hi All, I have three tables. First is basic information, where people are marked as type A, B, or C. Second is the question bank table, containing all the questions for them. There are two columns ...
Forum Discussion
Sounds like you could use a simple jinja If condition inside your weight field within the add bulk upsert row provided that in your Search step you've included both weight columns. To switch to code mode click on "</>" and then insert your code.
* assumes your step A is triggered when a new person is created, and your field names are most likely different from below, so adjust these as necessary:
{% If a.person_type == "C" %}
{{ b.weight_c }}
{% else %}
{{ b.weight_a_or_b }}
{% endif %}