Returning one component of a mangled foreign key - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13
Available in...

Data Fabric

MDM Platform

The getFK routine allows you to return one component of a mangled foreign key using tMap, for example:

You must use the getFK MDM routine in the lookup table in the Map Editor. Using the getFK routine in the editor, you can add/remove/update the foreign key components. In the above capture, the routine helps you to return the name component in the mangled foreign key.

You must do the same in a reversed case and use the createFK routine to return the foreign key string by a single key.