Skip to main content
Close announcements banner

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!