Modified Java Script Value

Script Types

You can right-click a tab in the Java script pane to open a context menu with the following commands:

• Add new – Add a new script tab.
• Add copy – Add a copy of the existing script in a new tab.
• Set Transform Script - Specify the script to execute for each incoming row. Only one tab can be set as a transform script. The first tab is a transform script by default.
• Set Start Script - Specify the script to execute before processing the first row.
• Set End Script – Specify the script to execute after the last row has been processed.
• Remove Script Type - Specify to not execute the script. The script tab is not removed. To remove a script tab, click the Close button (the red “X”) and choose Yes to delete the script tab.

The icon for the script type displays on the tab to denote the type of script on the tab. To rename a script tab, right-click the tab name in the Transform Scripts section of the Java script functions pane, choose Rename, and enter the new name.

Fields Table

The Fields table contains a list of variables from your script, and enables you to add metadata to the fields, like descriptive names.

Modify Values

To change an input value, enter the value in the Rename to field, and set the Replace value 'Fieldname' or 'Rename To' field to Y. The Rename to field (or if this is blank, the Fieldname field) is used to lookup an existing field and replace its value and metadata type. If the specified field does not exist in the input stream, an error is passed onto the next step indicating that the field to be replaced could not be found.

The following example changes the value of the field1 field in the input row with Compatibility mode selected:

field1.setValue(100);

setValue() takes all possible types that can be used in PDI.

Check for the Existence of Fields in a Row

The following code examples check for the existence of fields in rows:

var idx = getInputRowMeta().indexOfValue("lookup");
if ( idx < 0 )
{
   var lookupValue = 0;
}
else
{
   var lookupValue = row[idx];
}

With Compatibility mode selected:

var idx = row.searchValueIndex("lookup");
if ( idx < 0 )
{
   var lookupValue = 0;
}
else
{
   var lookupValue = row.getValue(idx);
}

 You cannot mix rows in PDI. All rows flowing over a single hop must have the same name, type, and number of fields.

Add a New Field in a Row

Fields must be added to the rows in the same order to keep the structure of the row coherent. To add a field, define it as var in the Java script pane, and add it as a field in the Fields table. 

Use NVL in JavaScript

NVL (replace null value function) lets you replace a null (returned as a blank) with a string in the results of a query. 

Select Compatibility mode and use the following code to replace the value of fieldName with the value of '1', if fieldName is null:

var a;
if ( fieldname.isNull() )
{
    a = '0';
}
else
{
    a = fieldName.getString();
}

You can also use:

fieldName.nvl('1');

Split Fields

Select Compatibility mode and use the following code to split a field containing numbers and characters, with inconsistent layout, and where the first part is numeric and the second part is characters (where Merchant_Code is the name of the input field):

java;
 
var str = Merchant_Code.getString();
 
var code = "";
var name = "";
 
for (i = 0; i < str.length(); i++ )
{
    c = str.charAt(i);
    if ( ! java.lang.Character.isDigit(c) )
    {
        code = str.substring(0, i);
        name = str.substring(i);
        Alert("code="+code+", name="+name);
        break;
    }
}

The Alert() displays the name of the fields. 

Comparing values

Values coming from the data row are Java objects, so you must use the compare methods that are specific to the Java object. For example, a compare between values with the operators "=", ">", "<" does not work.

The following examples are values that require the use of compare methods:

• String values
• Numeric Values
• Filter Rows

String values

Use the following method to compare strings:

string.equals(otherString)

Do not use the == operator for strings.

Use the following method to ignore case differences:

string.equalsIgnoreCase(otherString)

Numeric Values

Most values that are assigned in JavaScript are floating point values by default, even if you think you have assigned an integer value. If you are having trouble using == or switch/case on values that you know are integers, use the following constructs:

parseInt(num)==parseInt(num2)

or 

switch(parseInt(valuename))
{
case 1:
case 2:
case 3:
 strvalueswitch = "one, two, three";
 break;
case 4:
 strvalueswitch = "four";
 break;
default:
 strvalueswitch = "five";
}

Filter Rows

To filter rows (remove the rows from the output for example) set the trans_Status variable as follows:

trans_Status = CONTINUE_TRANSFORMATION
if (/* add your condition here */) trans_Status = SKIP_TRANSFORMATION

 All rows matching the specified condition are removed from the output.