Returning one component of a mangled foreign key
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.