Add If conditions - Automate_Studio - Latest

Add a condition

1. On the Map tab, select the fields you want to apply the condition to.
2. Click Create Condition from.

   If Create Condition from is grayed out, click the Expert View tab.

3. 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.
4. The column letter is shown on Column operand only. We show only column letter so cell number is not required.
5. 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.

6. 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.

7. To add another condition, click the plus sign.
8. 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

1. In the Mapper, click the row that contains the condition statement to select the row.
2. Right-click the row, and then click Delete.