Using Mapping Functions

You can map source and destination layout elements using the various mapping functions built-in the Web Mapper. All these mapping functions comprise of sub-functions, which are used to map elements.

Some mapping functions require the use of constant values for mapping elements. For this, you need to add the constant node to the Mapping Expression Area. Apart from these Mapping Functions, you can also use inbuilt mapper utility classes and global methods available in the Web Mapper to map the elements. Visit Mapper Utility page to know how to use utility classes.

Using Math Function

The Math mapping function enables you to map elements by performing simple mathematic operations. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Math	Add	Adds two numeric elements.	(10) + (5)returns 15
	Ceiling	Rounds a passed number to the smallest integer that is greater than or equal to the passed number.	Ceiling(33.9)returns 34
	Division	Divides two numeric elements.	(100) div(5) returns 20
	Floor	Rounds a passed number to the largest integer that is not larger than the passed number.	floor(33.9)returns 33
	Mod	Returns the remainder of a division between two numeric values.	(50) mod(3) returns 2
	Multiply	Multiplies two numeric elements.	(10) * (5)returns 50
	Round	Rounds a passed number to the nearest integer.	round(4.6)returns 5
	Subtract	Subtracts one numeric value from other.	(10) – (5)returns 5
	Number	Converts parameter to a number.	number("-17.3")returns -17.3
	Format number	Transforms input data into a specific format. By default it rounds off the value by considering only the digits before the decimal point. You may, however, specify the number of decimal places to be considered by increasing the count of hashes (#), it rounds off the last digit defined after decimal point, see corresponding example. The specific format allowed is decimal. This function can be used only if the target node is of string data type.	format-number(12.5746, '#.###')returns 12.575

You can use the required sub-function of Math mapping function to map elements. The process of using the Math function is the same for all its sub-functions.

Using String Function

The String mapping function enables you to map elements by manipulating strings. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
String	Concat	Concatenates the second string after the first string. This function accepts only two parameters in graphical mode. However, there is no limitation to the number of parameters in text mode.	concat ('Jane', 'Brown') returns the string JaneBrown
	Substring	Returns the sub string from the string starting from the specified position and of the specified length. When using this function, you always start counting its position from 1. This implies that the second argument (position) is always greater than or equal to 1.	substring ('abcdef' ,3, 4) returns cdef
	String	Returns the string value of the argument.	string ('1000') returns the string 1000
	Translate	Translates each occurrence of the first argument in the specified string to the second argument. Both the arguments must consist of one or equal number of characters.	translate ('alphabet', 'a','t') returns tlphtbet
	Substring-after	Returns the string after the specified argument from the string.	substring-after('print=yes', '=') returns yes
	Substring-before	Returns the string before the specified argument from the string.	substring-before('print=yes', '=') returns print
	Starts-with	Returns true if the string starts with the specified argument or false otherwise.	starts-with ('Sales', 'S') returns True
	String-length	Returns the length of the specified string.	string-length('adeptia') returns 7
	Contains	Returns true if the string contains the specified argument or false otherwise.	contains ('adeptia', 'tia') returns True
	Normalize-space	Removes leading and trailing white space (space, tab and new line) from a string, and replaces internal sequences of white space with a single space character.	normalize-space (' Adeptia Inc ' ) returns Adeptia Inc
	Name	Returns the name of the source node and field name on which mapping is currently done.	If the context node is an element named<ms:schema>, then name () will return ms:schema
	Local-name	Returns name with the name prefix. If no prefix was specified, then name and local name are same.	If context node is an element named<ms:schema>, then local-name () will return schema

You can use the required sub-function of String mapping function to map elements. The process of using the String function is the same for all its sub-functions.

Using Date Function

The Date mapping function enables you to map elements by generating dates in specific formats. It also returns the current date and the difference between two dates. It comprises of various sub-functions, which are listed in the table below.

All Date functions are applicable, only for XML Schemas at source and target.

Mapping Function	Sub-Functions	Description	Example
Date	Date-Format	This is a customized mapping function. Changes the date from the input date format to specified output date format.	date-format (employee/ 1998-03-31, 'yyyy-MM-dd', 'dd-MM-yyyy') returns 31-03-1998
	Date -Difference	Generates the difference between two dates in milliseconds. Supports all java date formats.	date-difference('12-08-2006','dd-MM-yyyy','12-08-2005', 'dd-MM-yyyy') returns 31536000000
	Current Date	Returns the current system date in Month-day-year format. It accepts the argument according to standard Java arguments as defined for SimpleDateFormat class.	current date ('MM-dd-yyyy') returns the current date in month-day-year format.

You can use the required sub-function of Date mapping function to map elements. The process of using the Date function is the same for all its sub-functions.

Using Aggregation Functions

The Aggregation function enables you to map elements by aggregating or counting the values of all nodes in an element. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Aggregation	Sum	Returns total of all values under all nodes of the specified element.	Sum (Age) returns the sum of all Age elements under the specified node.
	Count	Returns the total number of nodes for the specified element.	Count (Age) returns the total number of records under the Age element.
	Position	Returns the position of the current context node in the specified element.	position() returns 1 for the first node, 2 for second node and so on.
	Key	Returns matched records using two parameters: Name of a key to be used Fields to be matched	Refer to the Using Key Function section.

You can use the required sub-function of Aggregation mapping function to map elements. The process of using the Aggregation function is the same for all its sub-functions.

Using Conditional Function

The Conditional mapping function enables you to map elements by building conditional expressions. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Conditional	IF Conditions	This function comprises of two sub functions:
	For Filtering Records	Filters the records/elements on basis of the specified condition. Note: If filtering is applied at the parent record, IFF condition filters the records on the basis of given condition, and ignores the 'Value'. If you apply a condition at the child of parent, it returns the 'Value', given that IFF condition gets satisfied.	IFF CONDITION {Age=25} Value= [100] Returns the filtered target node-set/node if the Age is 25 in the source record.
	For Mapping To Elements	Returns a value if the specified condition is true.	IF CONDITION {Age=25} Value= [100] Returns 100 if the Age has the value of 25 in the source record.
	When Condition	Returns a particular value if the specified condition is true, else it returns another value.	WHEN Condition {contains (Email_ID, '@')} Value= [100] Otherwise Value= [200] Returns 100 if the Email_ID contains @, else it returns 200.
	Select Query	This is a customized mapping function. Returns the output based on the applied select query on a table in the any of the three databases (Oracle, Sql, IBM DB2). Select Query supports single field selection and returns first matching record.	SELECT FIELD = [Value1] FROM DB.TAB = [Value2].[Value3] WHERE {Condition} Here: Value1 = Field name in the table, whose value is to be retrieved Value 2 = Name of the Database Info object where the table exists. It contains database location and the user ID and password to connect to that database. Value 3 = Name of the table for which the select query is implemented Condition = Condition, based on which value is returned For example: SELECT FIELD = [EMPNO] FROM DB.TAB = [oracle_databaseserver].[EMP] WHERE {ENAME= 'Smith'} Returns Employee number of an employee from the table EMP with the name Smith. SELECT FIELD = [EMPNO] FROM DB.TAB = [oracle_databaseserver].[EMP] WHERE {[ENAME= 'Smith'] AND [AGE = 28]}
	Sequence	This is a customized mapping function. Returns integer values starting from the first argument and incrementing it by the second argument for each record. Both the arguments must be integer constants.	Sequence {10, 20} Returns 10, 30, 50….and so on.

Some conditional sub-functions are not included in the Web Mapper screen, but are implemented by extending the 'IF' and 'When' conditions. These sub-functions are listed in Table below.

Mapping Function	Sub-Functions	Description	Example
IF Condition	Nested IF	Contains IF condition inside the value of previous IF condition. Returns output when all IF conditions are satisfied. For example: IF CONDITION {condition1} VALUE=[IF CONDITION {condition2} VALUE=[IF CONDITION {condition3} VALUE=[Value1]]] Returns Value1 when all IF conditions are satisfied.	IF CONDITION {Age=25} Value= [IF CONDITION {#Designation= 'Manager'} Value = IF CONDITION {Salary= 20000} Value = [100]]] Returns 100 if all conditions are satisfied such that a manager of age 25 has a salary of 20000.
When Condition	Nested When	Contains When condition inside the value of previous When condition. Returns varied output based on the When conditions being satisfied. For example: WHEN CONDITION {condition1} VALUE=[WHEN CONDITION {condition2} {VALUE=['value1'] OTHERWISE VALUE=['value2']] OTHERWISE VALUE=['value3'] Returns Value1 when both When conditions are satisfied. Returns Value3 when the first When condition fails. Returns Value2 when the first When condition is satisfied, but the second one fails.	WHEN CONDITION {/employees/employee/Age=25} Value= [WHEN CONDITION {/employees/employee/Designation= 'Manager'} Value = ['100'] OTHERWISE Value = ['200'] OTHERWISE Value = ['300']] Returns 100 if both conditions are satisfied such that the employee is a manager of age 25. It returns 300 if the employee is a manager but not of 25 years of age. It returns 200 if the employee is 25 years of age, but is not a manager.
IF and When Condition	IF and When conditions return Boolean	Returns value based on the function used as whether the condition returns True or False. If a string or source element contains a character or group of characters, then True is returned, else False is returned. Based on the return value of the condition, the output value is generated. For example: WHEN CONDITION {contains (var1, str)} VALUE=[var2] OTHERWISE VALUE=[var3] If var1 contains str, then True is returned, else False is returned. If the condition returns True, then var2 is generated as output, else var1 is the output value.	WHEN CONDITION {contains (var1, str)} Value= ['100'] OTHERWISE Value = ['200'] Returns true if Var1 contains Str, else it returns False. If the condition returns true, then this function returns 100, else it returns 200.
IF and When Condition	Mixed condition	Contains IF condition inside the value part of When condition or vice versa. Returns varied output based on the conditions being satisfied. For example: WHEN CONDITION {condition1} VALUE=[IF CONDITION {condition2} VALUE=['value1']] OTHERWISE VALUE=['value2'] Returns Value1 when both conditions are satisfied. Returns Value2 when the first condition fails. Returns no output when the first condition is satisfied but second condition fails or when both conditions fail.	WHEN CONDITION {/employees/employee/Salary=50000} Value= IF CONDITION {/employees/employee/Designation= Project Manager} Value = ['100'] OTHERWISE Value = ['200'] Returns 100 if the employee is a Project Manager and has a salary of 50000. It returns 200 if the employee is a Project Manager but does not have a salary of 50000.
IF Condition	Multiple IF	Contains IF conditions placed sequentially, with each IF having its value part. Two IF conditions are appended using Append sub-function of the String Function. Returns varied output based on the condition being satisfied. For Example: IFCONDITION {condition1} VALUE=['value1'] IF CONDITION {condition2} VALUE=['value2'] Returns Value1 if condition1 is satisfied. Returns Value2 if condition2 is satisfied.	IF CONDITION {Age=25} Value= ['500'] IF CONDITION {Designation= 'Manager'} Value = [1000] Returns 500 if an employee is of age 25. It returns 1000 if an employee is a Manager.
When Condition	When condition with more than one conditions in it.	Contains When condition containing logical operators like and/not to make multiple conditions inside the When condition. There are many permutations/combinations for this sub-function. Example 1: WHEN CONDITION (cond1 and cond2) Value = ['value1'] otherwise value = ['value2'] Returns Value1 if both conditions are satisfied, else returns Value2. Example 2: WHEN CONDITION (cond1 or cond2) Value = ['value1'] otherwise value = ['value2'] Returns Value1 when either one or both conditions are satisfied, else returns Value2.	WHEN CONDITION {/employees/employee/Age=25 and /employees/employee/Designation=Manager} Value= ['100'] OTHERWISE Value = ['200'] Returns 100 if both conditions are satisfied such that the employee is a manager of age 25. Else it returns 200.
IF Condition	IF condition with more than one conditions in it.	Contains IF condition containing logical operators like and/not to make multiple conditions inside the IF condition. There are many permutations/combinations for this sub-function. Example 1: IF CONDITION (cond1 and cond2) Value = [] Returns Value1 when both conditions are satisfied, else no output is returned. Example 2: IF CONDITION (cond1 or cond2) Value = [] Returns Value1 when either one or both conditions are satisfied, else no output is returned.	IF CONDITION {/employees/employee/Age=25 and /employees/employee/Designation=Manager} Value= ['100'] Returns 100 if both conditions are satisfied such that the employee is a manager of age 25. Else it returns 200.

You can use the required sub-function of Conditional mapping function to map elements. The process of using the Conditional function is the same for all its sub-functions.

Using Axis Function

The Axis function contains a list of advance XSL functions that are used to map elements only when the For Each function is applied on the Target node. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Axis	File Path – XPath	This is a customized mapping function. This is an XML Lookup which returns the value of the element/attribute within the XML file whose path is specified. The File path and XPath must be specified in single quotes.	FilePath ['C:/correct_file.xml'] XPath {'/employees/employee/Name'} Returns value of Name element from the file correct_file.xml.
	Self	Returns the element which is the context node itself.	Self::Employee Returns Employee which is the context node itself.
	Child	Returns the element which is the child of the context node.	Child::Name Returns Name which is a child of the context node.
	Parent	Returns the element, which is the parent (if any) of the context node.	Parent::Name Returns Name which is a parent of the context node.
	Following-sibling	This axis contains all the following siblings of the context node. It returns the first occurrence of the element/attribute in the next sibling of the context node. If the context node is an attribute node or namespace node, then this axis is empty.	following-sibling: employee/Name Returns the first occurrence of Name in the next employee node.
	Ancestor	Returns the element which is the ancestor of the context node. This axis always includes the root node, unless the context node is the root node.	Ancestor::Name Returns Name which is an ancestor of the context node.
	Ancestor-or-self	This axis contains the context node and the ancestors of the context node. It always includes the root node. It returns the context node or ancestors of the context node.	ancestor-or-self::employees/@val Returns context node or ancestors of context node.
	Preceding-sibling	This axis contains all the preceding siblings of the context node. It returns the first occurrence of the element/attribute in the preceding sibling of the context node. If the context node is an attribute node or namespace node, then this axis is empty.	preceding-sibling: employee/Name Returns the first occurrence of Name in the previous employee node.
	Descendant	Returns the element which is the descendant of the context node. This axis does not contain attribute nodes.	descendant::Name Returns Name, which is a descendant of the context node.
	Descendant-or-self	This axis contains the context node and the descendants of the context node. It returns the context node or descendants of the context node.	descendant-or-self::employees/salary Returns context node or descendants of context node.
	Generate-id	Generates a unique id for the element/attribute specified by the XPath argument.	generate-id (employees/employee/Name) Returns unique ID for Name element
	Current	Removes all tags from the specified xml file and returns the data.	current() Returns data of the xml file without tags.

You can use the required sub-function of Axis mapping function to map elements. The process of using the Axis function is the same for all its sub-functions.

Using Boolean Function

The Boolean mapping function enables you to map elements by applying various logical operators in building Boolean expressions. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Boolean	Equal	Returns TRUE the first variable argument is equal to the second variable argument.	(5) = (5)returns true
	Not Equal	Returns TRUE the first variable argument is not equal to the second variable argument.	(5) != (50)returns true
	Greater Than	Returns TRUE the first variable argument is greater than the second variable argument.	(5)> (3)returns true
	Less Than	Returns TRUE the first variable argument is less than the second variable argument.	(5) < (8)returns true
	Greater than Equal	Returns TRUE the first variable argument is greater than or equal to the second variable argument.	(5)>= (5)returns true (5)>= (3)returns true
	Less than Equal	Returns TRUE the first variable argument is less than or equal to the second variable argument.	(5) <= (8)returns true (5) <= (5)returns true
	Or	Returns TRUE if either of the two variable arguments evaluate to TRUE otherwise FALSE. These variable arguments can only be of Boolean data type. Hence, their value can either be TRUE or FALSE only.	(True) Or (True) returns true (True) Or (False)returns true
	And	Returns TRUE if both of the two variable arguments evaluate to TRUE otherwise FALSE. These variable arguments can only be of Boolean data type. Hence, their value can either be TRUE or FALSE only.	(True) And (True) returns true (True) And (False)returns false

A Boolean sub-function is always used in conjunction with a Conditional function.

Using Context Functions

The Context mapping function enables you to map elements by setting or getting the value of process flow context variables. It comprises of various sub-functions, which are listed in the table below.

Mapping Function	Sub-Functions	Description	Example
Context	Set-Context	This is a customized mapping function. Sets the value of the specified variable argument in the process flow context. This value can be string constant, numeric constant, XPath or output of limited set of mapping function, which can be used before set-context function. This function does not return a value. If mapped to a target element, it creates an empty tag of that target element in output XML.	set-context ('index', '123') sets the value of index variable as 123 in the process flow.
	Get-Context	This is a customized mapping function. Returns the value of the specified variable argument from process flow Context. This value can be string constant, numeric constant, XPath or output of a limited set of mapping function. If no value has been set, then the value specified in the second argument is returned.	get-context ('index', '100') Returns the value of index variable from the process flow. If no value has been set for index, then 100 is returned. In get-context function you can also use any variable, which is not declared. In such case get-context creates a variable with the specified name and value, which can be further used with the selected target element. This can be done only in Textual Rule panel.

Adeptia Connect Help