This content has been marked as final. Show 6 replies
In case if you want to handle Foreign Connector then create a Post Event Handler (would be easy ) for generating Display Name.
You can create a field in reconciliation staging and concat 1 and 2 into this new field.
You can concat this new field and the 3rd field from source and puit in your target field.
Will FN + MN + LN end up in the correct order though?
I mean...it is not possible to concatenate a source field with a stage field ... only 2 source fields.
Re-mapping the FN+LN concatenated field to DiplayName resolved the issue of DisplayName not getting populated if either FN or LN had a special character.
However, now the DisplayName contains a '?" if either FN or LN is something like Jose' (Jo?e) or Andre' (Andre?).
Running SQL> select USR_DISPLAY_NAME from USR where USR_DISPLAY_NAME LIKE '%?%';
Returns 250 rows.
I'm thinking it is the grave sign that is problematic, as the single quote shows up fine in last names.
Turns out the source data does not represent the use of non-English characters in names very well. Will get this fixed.
Thanks for looking.