====== AddLookupKeyValue ======

The function **AddLookupKeyValue ()** creates the value, if it does not yet exist, as [[en:transformation:werteprovider:start]]((ValueProvider Entry)) and assigns it to the [[en:transformation:mappings:funktionen:abfragefunktionen:lookup:addlookupkeyvalue|LookupTableKey]], or changes the value if LookupTableKey exists.

{{:images:sign_warning.png|}}**Note:** Existing lookup key-value pairs are updated with the new value.

{{:images:sign_warning.png|}}**Note:** This function is inactive in the [[en:transformation:mappings:debug|DEBUG]] mode. 


==== Syntax: ====

<code>AddLookupKeyValue('LookupTable', 'LookupTableKey', 'ValueProviderValue')</code>

==== Sample 1: ====

<code>AddLookupKeyValue('Manufactorer-Retailer-Color', '47A11', '992855')</code>


==== Sample 2: ====
With this function you can e. g. Temporarily store information in the converter that cannot be processed by a host system. The trading partner sends ORDERS with a specific reference that is not in the ORDERS (INHOUSE) space.

**preconditions:**
Create a [[en:transformation:werteprovider:start]]((ValueProvider)) to which the references can be added. Then, create a [[en:transformation:wertetabellentypen:start]] and assign the values from [[en:transformation:werteprovider:start]]((ValueProvider)) to it. Then create a new [[en:transformation:wertetabellentypen:anlegen|LookupTable]]. Give these objects a descriptive name (here in the example' MyLookUpTableName' is used for all objects).

The reference can now be created with a unique key as a new lookup entry as follows:
<code>AddLookupKeyValue('MyLookUpTableName', concat($LocationGLN,$DocNumber), SG_1/RFF/DG_C506[@DE_1153='CR']/@DE_1154)</code>

This reference can then be read out during the transformation of eBiss.Industry.DespatchAdvise to eBiss.MappingObjects.Edifact.D96A.Messages.DESADV.DESADV by restoring the unique key with e. g.:
<code>concat(@DeliveryPartyGLN,@ReferenceBuyerOrder)</code>
and with and therefore with:
<code>LookupGlobalValue('concat(@DeliveryPartyGLN,@ReferenceBuyerOrder)',$RFF_CR)</code>
and can thus be written away at the desired position in the target object.



{{:images:sign_warning.png|}}**Note:**  AddLookupKeyValue() can also be added to the [[en:transformation:mappings:funktionen:schreibfunktionen:start]]