eBiss 3

Hilfe & Dokumentation

User Tools

Site Tools


en:transformation:mappings:funktionen:abfragefunktionen:lookup:lookupglobalkey

Table of Contents

LookupGlobalKey

This function basically corresponds to the mapping function LookupGlobalValue. However, the key is queried for the value and LookupGlobalKey gets an additional Key and the Key-Description, as parameters which are used to create new table fields when the key is not found.

Syntax:

LookupGlobalKey('LookupTabellenNamen','Key', 'Description')
LookupGlobalKey('LookupTabellenNamen','Key', 'Description', 'Value', 'Description')

Sanmple:

LookupGlobalKey('currencies','5','Country code Switzerland')
LookupGlobalKey('currencies','5','Country code Switzerland', 'SFr', 'Currency Switzerland')
en/transformation/mappings/funktionen/abfragefunktionen/lookup/lookupglobalkey.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1