For greater control over the data that gets posted to SAP, you can add If conditions to a field or fields. Every field in the If condition is checked against the condition and is processed only if it meets the condition.
Studio supports two levels in a condition.
Add a condition
- On the Map tab, select the fields you want to apply the condition to.
- Click Create Condition from.
If Create Condition from is grayed out, click the Expert View tab.
- In the If Condition box, choose the operand.Note: If you choose First Transaction or Not First Transaction, click OK or click Add New Group to add more conditions.
- Based on the operand that you chose, do one of the following:
- Click the SAP field.
- Click the column letter or cell number, and then click Go.
- Choose an operator, such as Greater Than. Note: The Between operator includes both of the specified values as well as the values between them.
Transaction with Evolve does not currently support linked dynamic list files that are used by the In List and Not In List operators.
- Do one of the following:
- Type the value for the condition.Note: If the value contains decimal places or long text, be sure your data read preferences are set to As stored. Click the File tab, click Options, click Data, and then click As stored.
- Check the Compare with Column box, choose the column letter that
contains the value you want Studio to compare, and then click
Go.
For example, you can select the column that contains Gross Weight, select the Is Greater Than operator, check the Compare with Column box, and select the column that contains Net Weight.
- Type the value for the condition.
- To add another condition, click the plus sign.
- To add a second level to the condition, click Add New Group (for example, IF ((A=1 & B=2) OR IF First Transaction), Then repeat steps 3-6.
If condition operands
First Transaction Use this operand when a entity or action is only required in the first record. This condition will not be applied to the second record and any subsequent records.
Not First Transaction Use this operand when a entity or action is only required on the second record and any subsequent records. This condition will not be applied to the first record.
Column Use this operand to specify whether a entity, field, or action should occur based on static values or values in your data file.
Change the condition
Click the condition statement to reopen the Condition box, and then make the changes that you want. You can edit the condition of an empty If block or Loop block.
Cut, copy, and paste the If condition
You can cut and copy a nested If-else condition block and paste it anywhere in the Mapper.
Use the replace, insert before, and preserve options
You may use the replace, insert before, and preserve options for column mapping in an If condition.
Delete the condition
- In the Mapper, click the row that contains the condition statement to select the row.
- Right-click the row, and then click Delete.