For ObjectFilter you should specify a WHERE clause statement that is similar to SQL Syntax. Only the part that is in the WHERE clause should be included. Examples: TxnDate = '2020-09-29' Active in (True, False) CustomerRef ='123' Active=true ...
The composite record output contains not only fields from the composite record, but also the parent records. The output will be populated with sets of records, one set for each parent record. Each set of records is separated with a blank row (all ...
The source object, query and parent are available in the data flow properties list. Follow these steps to set up an expression: Right-click on the data flow canvas and select the Properties menu. Scroll down and find the property named like ...