In an import scenario, is it possible to add a condition on an action row, specially the <Line Number> action?
Use case:
In an import scenario for sales order, the data provide has a single row per sales order. Based on a value in one of the columns, sometimes we need to create 1 line item and sometimes 2 line items.
The idea would be to add a condition on the second <Line Number>, something like =iif([MyVal]=1, -1,null), where the -1 adds a row, and if the condition is not met the null will ensure no rows are added.
So far, I have not been successful adding any formulas in there. Not even a single Cint() formula without conditions.
