Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If the target node is not a loop node, the function returns 1. See also the SourceInstanceCount() function.

Note

NOTE: The streaming mode of a Flat-to-Flat transformation would not be affected by the use of this function, while the streaming mode would be turned off for an XML-to-Flat transformation.

...

Searches multiple instances of a data element (de1) looking for the value specified in v. If the function finds the value, it returns the value in the field specified in the third parameter (de2) for that found instance. If the value is not found, the function returns null. See also the HasKey() function.

Examples

This statement will search the instances of B under A and check the contents of field1. It will select the first instance of B it finds where field1 contains "ID", and then return the value of field2 from that same instance:

...

These statements show how to implement a test of an array for inclusion of a value. It searches an array for a value, and returns true if found and false if not. It is the array-equivalent to the dictionary HasKey() function. Note that two instances of the same array are passed to the function:

...

This function returns the instance data element which was defined by calling a SetInstances() function during the generation of the parent. As an alternative to this function, see the ArgumentList() function.

Examples

Assume one of the parent mappings of a transformation contains these statements:

...

To see how to use an instance data element, see the GetInstance() and ArgumentList() functions.

This function should be called in the mappings of the parent node of the intended target. If no leaf node is available in the parent, you can create a condition node that calls this function. The condition should end with true so that it always is accepted.

...

If the field or array element contains special characters such as line feeds or commas, the field or array element is enclosed by double quotes. No delimiter is added after the last instance or element is concatenated.

See also the SumString() function for a similar function but with additional options.

...

If the parameter omitlast is true, the delimiter after the last string is omitted.

See also the SumCSV() function.

Examples

Code Block
// Concatenates all instances of a field of email addresses
// with a comma between each address,
// but does not place a delimiter after the last address
SumString(_Root$customer.contact#.Email, ",", true);

...