Maintaining table in Integration Directory

[Former Member]

Hi,

I was trying to use value mapping for maintaining values in ID, but as the 2nd column has got repeating values , I am not able to form a value group. Please suggest what can I use for the same.

Eg :- CompId --- 9916 CompCode 78

CompId --- 9999 CompCode 78

The values are not being accepted in the value group as the agency and scheme are same. Please let me know how can I maintain a table in ID which can be used in ESR.

Thanks,

Neelansha

[Former Member · Accepted solution]

Hi

You can use the same value by adding incremental value and in ESR you can use substring or split function to recover the comp code.

<001>_<compcode>
<002>_<compcode>

Regards

Ramg

[Former Member]

Hi Neelansha,

You have to do little work around here, your source values is common then to make them unique add some identifier in the begining say X1 company ID and in table maintaine X1 company ID and value

and if your tagert values are common then add some values at the end say 9916 CompCode 78X1,9916 CompCode 78X2 etc.

and in the mapping afte the value mapping fucntion use the substring function to read till 9916 CompCode 78 and ignore last two characters.

Regards,

Srinvas