• State Suggested Answer
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 93 subscribers
  • Views 50 views
  • Users 0 members are here
Options
Related

Data Mapping

imkhonza
21 days ago

Hi, 

I have an HR system that is sending me gender as M/F and I need to transform that to 1/0. 

How can I do that?

Thanks

Parents
  • 0 15 days ago

    I managed to resolve this issue. Created a virtual attribute as a code/script based attribute that reads the target system attribute and transfomed it to the type I need. Then mapped that to the IAM attribute.

    Dim oGender As String = $gender$
Dim iamGender As Integer
oGender = UCase(oGender)
If oGender = "M" Then
    iamGender = 0
Else
    iamGender = 1
End If
return iamGender

Reply
  • 0 15 days ago

    I managed to resolve this issue. Created a virtual attribute as a code/script based attribute that reads the target system attribute and transfomed it to the type I need. Then mapped that to the IAM attribute.

    Dim oGender As String = $gender$
Dim iamGender As Integer
oGender = UCase(oGender)
If oGender = "M" Then
    iamGender = 0
Else
    iamGender = 1
End If
return iamGender

Children
No Data