Mapping Two Target field in Transform Map

[Ankit Singh4]

Hi Team,

I am stuck in a requirement where I need to transform data from source table into target table.

Requirement is: I am getting two types of records in source table field called as req_ref_id:
Types of Records:

1. One record start with ABC000001123
2. Second one start with XYZ00000123456

Now, to avoid duplicity of records I need to use coalesce but the problem is I can map only one target field at a time and above both data is inserting into different fields of target table. ABC000001123 --inserting in Number field of target table and XYZ00000123456 is getting inserted in seq_ref_id reference field.

So, It's become like if data comes for ABC target field and coalesce should be "number" and if data comes for XYZ target field and coalesce should be seq_ref_id.

Any help will be really appreciated.

Thanks,

Ankit Singh

[Dhanalakshmi D]

Hi Ankit,

This would help you, please check.

https://www.servicenow.com/community/developer-forum/coalesce-on-two-fields-in-transform-map-inserti...

Thanks

[Ankit Singh4]

Hi Dhanalakshmi,

Appreciate your response.

Provided link does not fulfil my requirement as both are having different scenarios.

Thanks,

Ankit Singh