...
All fields of this step support metadata injection. You can use this step with ETL Metadata Injection to pass metadata to your transformation at runtime.
Special considerations Considerations for the Condition fieldField:
The Filter Rows step is a special MDI scenario, since it has a nested structure of filter conditions. The condition is given in XML notationformat. The condition XML has the same format as we store the transformation meta data metadata in a .KTR file in XML format. We do not have a DTD (Document Type Definition) for the .KTR XML format, nor the condition.
It is easy to get to a an XML condition:
- Create a sample Filter step with the different conditions you need. This sample step gives you all the information, for example such as the values for the functions you use.
- Select the step and Copy , copy it to the clipboard. Paste , and then paste it into a text editor. Alternatively, you can store the .KTR, and then open the .KTR in a text editor.
- Find the <condition> element and their its nested elements and modify it accordingly to use it in your MDI scenario.