Help with FixValues mapping

[Former Member]

Hi all,

I have to map a field using FixValues

For example

FIELD_INPUT_VALUE   FIELD_OUTPUT_VALUE
A                   01
B                   03
C                   06
D                   07
....

My conversion table contains a lot of entries, is there a way to import those values (for example from excel or flat file) instead of manual insert ? It could spare me a lot of time (and errors!).

Thank you very much!

Manuel

[Former Member · Accepted solution]

Hi Manuel,

You can build a Java Code with the relevant if/else blocks in an editor. You can use copy and paste the values from a text or excel file for easier editing.

Then paste this code into a Custom Java Function in the XI Message Mapping.

Hope this helps,

Bhanu

[manuel_bassani · Accepted solution]

Thank you for your help, i think i will write some java code ...

Regards, Manuel

[MichalKrawczyk]

Hi Manuel,

sorry there's no way to import those I believe:)

Regards,

michal