i have to map the nominated person in excel with subject person in hr case.

[Burra Mounika]

I have to map the nominated person in excel with subject person(sn_hr_core_case_benefits)table in hr case.I need to get the user id(email-id)  of the subject person from the back end table i.e.,(sys_user.do) table.For that i need to write source script in Field map.How can i write that?

[Ravi Chandra_K]

you can try

userRecord.addQuery('user_name', source.email_id)

[Burra Mounika]

Hey Ravi chander,

this is not working as expected.

Actually my requirement is 

need to add columns HR Case Number, Last date of gift card received, Nominated Person in the excel. 

- The date field should be updated only if the HR Case number and Subject person matches with the data in excel. Mapping should be -

    HR Case Number- Number

    Nominated Person- Subject Person

    Last date of gift card received- Last date of giftcard received

Now when i created field map it is not getting mapped correctly.so i thought to write source script in field map for these two below field maps:

HR Case Number- Number(this one iam not getting how to map.

  Nominated Person- Subject Person(this one when i give user id in the excel sheet it has map correctly with nominated person in HR case table).

Can you help me in this?

[Ravi Chandra_K]

Hello @Burra Mounika 

Now when i created field map it is not getting mapped correctly.

if the related field exits in target table, it will map correctly only.

could you pls provide any more screenshots to better understand the use case.

[Ravi Chandra_K]

Thank you for marking the answer as helpful.

if you were able to do this, accept the appropriate answer as solution and close the thread so that it benefits future readers.

Kind Regards,

Ravi Chandra.

[ghkygkfyughikjy]

illlllll