IF…ELSE…ENDIF 

Allows conditional processing within a script.  Accessed via Script Editor | Tools | IF ELSE ENDIF;

3 methods will be added to the script:

• IF
• ELSE
• ENDIF

NOTE: ELSE is optional and can be removed if not required

Helper

Right-click in JSON to bring up evaluation options:

• true
• false
• count field
• count table
• exists
• empty
  

{
  "method": "IF",
  "condition": "empty([table])",
  "project": "project"
}

{
  "method": "IF",
  "condition": "count([table.field],value)==?",
  "project": "project"
}

{
  "method": "IF",
  "condition": "count([table],*)==?",
  "project": "project"
}

{
  "method": "IF",
  "condition": "exists([table])",
  "project": "project"
}

{
  "method": "IF",
  "condition": "true",
  "project": "project"
}

{
  "method": "IF",
  "condition": "false",
  "project": "project"
}

IF METHOD

{

  "method": "IF",

  "condition": "",

  "project": "project"

}

Note: The IF method must be accompanied by an ENDIF method:

{

  "method": "ENDIF",

  "project": "project"

}

It is possible to embed IF…ENDIF statements inside each other, but care must be taken to verify processing logic

IF Conditions

If the IF condition in a script evaluates as TRUE, then the methods inside the IF block will be executed.    If the IF condition evaluates as FALSE then the block will be skipped and “skipped” will be displayed in the Scripting Panel Status column.  

Operators

Variable evaluation

Script Variables (as defined using the DEFINES method) can be accessed within IF Conditions:

{

  "method": "IF",

  "condition": "%MyVariable% != ActiveConfig",

  "project": "project"

}

{

  "method": "IF",

  "condition": "%HeaderRow%==5",

  "project": "project"

}

{

  "method": "IF",

  "condition": "%HeaderRow% > %StartRow%",

  "project": "project"

}

Distinct Value Counts for Fields

To check counts for fields, use the following syntax:

count([table.fieldname],value) = XXX

For example:

{

  "method": "IF",

  "condition": "count([customer.surname],smith)>20",

  "project": "project"

}

This condition will evaluate as true if there are more than 20 customers with the surname smith in the customer table.

Note: The condition is case sensitive.   Smith <> SMITH <> smith

Evaluating the number of rows in a table

To check counts for tables, specify the table and use the *value:

count([customer],*) > XXX

For example:

{

  "method": "IF",

  "condition": "count([customer],*) > count([addresses],*) ",

  "project": "project"

}

This condition will evaluate as true if there are more records in the customer table than there are in the addresses table

Dataset Counts

To check counts for dataset, chose a dataset that has been saved to a table, and evaluate using the possible dataset values of:

• null
• 0
• 1
• Total

count([customer.dataset_segment],1) > XXX

For example:

{

  "method": "IF",

  "condition": "count([customer.segment1],1)>1000",

  "project": "project"

}

This condition will evaluate as true if there are more than 1000 customers in segment 1.

ELSE method

Optional.   Must be used in conjunction with both IF and ENDIF.    If an ELSE method is encountered without a corresponding IF and ENDIF method, the script will generate a “Bad Condition” result, and the script will fail. 

The ELSE block is the code that is executed if the IF condition evaluates to FALSE.

{

  "method": "ELSE",

  "project": "project"

}

ENDIF method

Required.    Must be used in conjunction with an IF method, and may also be preceeded by an ELSE method. 

{

  "method": "ENDIF",

  "project": "project"

}