If the target node is not a loop node, the function returns 1. See also the
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
This statement will search the instances of
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
Assume one of the parent mappings of a transformation contains these statements:
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
// 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);