# MDM routine
Availability-note[Deprecated](https://help.talend.com/r/en-US/Cloud/labels-on-talend-help-center/availability-deprecated)
This content is deprecated.
Available in...
* Data Fabric
* MDM Platform
* Qlik Talend Cloud Enterprise Edition
* Qlik Talend Cloud Premium Edition
The table below lists some useful MDM routine functions including those for mangling foreign keys. In MDM, you usually need to mangle foreign keys to accommodate to compound keys.
Useful MDM routine functionsUseful MDMMDM routine functions
| Function | Description | Syntax |
| --- | --- | --- |
| getFK | Returns one of the foreign key components by position in a mangled foreign
key.
Note that the position is specified by an integer starting
from 0. | MDM.getFK
For example:
getFK("[fk1][fk2][fk3]",1),
which
will return the second foreign key component in the composite
foreign key. The output message will be "fk2". |
| getWSClientTimeout | Gets webservice client timeout information from jvm param
setting. | MDM.getWSClientTimeout(String property) |
| createFK | Returns the foreign key string by a single key (String singleKey). | MDM.createFK
For example:
createFK("0"),
which will return a
foreign key created with the id provided. The output message will be
"[0]". |
| createFK | Returns the foreign key string by a key list (String[] keys). | MDM.createFK
For example:
createFK({"0","1"}),
which will return a foreign key with the ids provided. The
output message will be "[0][1]". |
| createReturnMessage | Generates an error message with the content of msg
and error code of code. | MDM.createReturnMessage(String msg, int
code) |
| createReturnMessage | Generates a report message with the content of msg
and type of type. | MDM.createReturnMessage(String msg, String
type) |
| getRepeatingElement | Gets repeating element in an XML string according to the xpath and
position.
Note that the position is specified by an integer
starting from 0. | MDM.getRepeatingElement
For example:
getRepeatingElement("<Product><Features><Feature>color</Feature><Feature>size</Feature></Features></Product>","/Product/Features/Feature",1),
which
will extract the second multi-occurrence element described by the
xpath node from the XML string provided. The output message will be
"size". |
| hasRepeatingElement | Checks repeating elements in an XML string according to the xpath and the
text. | MDM.hasRepeatingElement
For example:
hasRepeatingElement("<Product><Features><Feature>color</Feature><Feature>size</Feature></Features></Product>","/Product/Features/Feature","size"),
which
will return the result about whether the specified multi-occurrence
element described by the xpath node and the text "size"
exist in the XML string provided. The output message will be
"true". |
| listRepeatingElement | Lists repeating elements in an XML string according to the xpath and the
delimiter.
Note that the delimiter is wrapped by single
quotes. | MDM.listRepeatingElement
For example:
listRepeatingElement("<Product><Features><Feature>color</Feature><Feature>size</Feature></Features></Product>",
"/Product/Features/Feature",',')
,
which will list all the multi-occurrence elements
described by the xpath node from the XML string provided with the
specified delimiter. The output message will be "color,
size". |
| addRepeatingElement | Adds repeating elements in an XML string according to the xpath and the
text. | MDM.addRepeatingElement
For example:
addRepeatingElement("<Product><Features><Feature>color</Feature><Feature>size</Feature></Features></Product>",
"/Product/Features/Feature","model"),
which
will add a new multi-occurence element described by the combination
of the xpath node and the text to the XML string provided. The
output message will
be
```
color
size
model
```
. |
| setLanguageVariant | Adds or updates an ISO variant to the multilingual text value. | MDM.setLanguageVariant
For example:
setLanguageVariant("EN","abc","[EN:ab][FR:ab\_fr]"),
which will update the EN variant to be "abc". The
output message will be [EN:abc][FR:ab\_fr]. |
| setLanguageVariant | Adds or updates an ISO variant to the multilingual text value with the
default ISO and the sort option for the output message.
If the sort
option is set to "true", the message will be output in
alphabetical order. | MDM.setLanguageVariant
For example:
setLanguageVariant("FR","ab\_fr","ab","EN",
true), which will add the FR variant "ab\_fr".
The output message will be [EN:ab][FR:ab\_fr]. |
| getLanguageVariant | Gets an ISO value from a multilingual text value with the default ISO
fallback.
If the ISO value requested is not found, the default ISO
value will be returned. | MDM.getLanguageVariant
For example:
getLanguageVariant("DE","EN","[EN:ab][FR:ab\_fr]"),
which will return the default EN value "ab" because the DE
value requested is not found. |
| getLanguageVariant | Gets an ISO value from a multilingual text value.
If the ISO value
requested is not found, the null value will be returned. | MDM.getLanguageVariant
For example:
getLanguageVariant("FR","[EN:ab][FR:ab\_fr]"),
which will return the requested FR value "ab\_fr". |
### In this section
* [Returning one component of a mangled foreign key](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-01/returning-one-component-of-mangled-foreign-key)
* [Handling ISO variants or get an ISO value from a multilingual text](https://help.qlik.com/talend/en-US/studio-user-guide/8.0-R2025-01/handling-iso-variants-or-get-iso-value-from-multilingual-text)