PI Message Mapping help with functions

[former_member201275]

Hi,

Please can someone advise me on the best way to do the following.

The fields im_firstname, im_id, im_lastname will all either contain an 'x' or a space.

All of the entries with an 'x' should be concatenated to the field 'id'. For example if im_firstname = 'x' and im_id = 'x', then id must contain 'FirstName&Id&'.

If all 3 import fields have an 'x', then id field must contain 'FirstName&Id&LastName&'.

I am new to using these functions so am not sure how this can be achieved.

All help and tips are greatly appreciated.

[peter_karg · Accepted solution]

Hi, one solution could be to use the Fixvalue Conversion, where you can replace the x to the needed values e.g. FirstName&, default nothing and then concatenate the fields. Regards Peter