Can anyone provide a working example or description of exactly how to configure the Condition Field
in the Logic Blocks
subtable when creating a Data Import? I couldn’t find anything in Help when I searched on this and I’m not sure if it needs to be a pre-process logic block or what. There’s the additional Condition
field too which I can’t really figure out what it’s for either.
Conditional Logicblock Use
This feature is used to conditionally skip rows from the input file. For example, this can be helpful to filter out invalid rows or rows already processed. Any row skipped will not be inserted by the import process.
Field Descriptions
Condition Field: A true/false field that holds the value to be checked.
Condition: The value that will trigger a skip of the record. If your condition is then any call to this LogicBlock that returns true in the Condition Field will skip the row. The reverse is true for a condition of false.
Valid Logicblock Types
Pre-Process: The input of a Pre-Process LB must only accept Text fields, but the output can pass a true/false field in this case. If a record is skipped at this point, no additional processing such as Table Lookups or Post-Process LBs will be called.
Post-Process, Post-Process (Insert Only), Post-Process (Update Only)