Behaviour of Transform Field map when Reference field value not given!

[Wasif]

While creating a field map for a reference field in the Transform Map, we generally give a value in the 'Reference field value', however if we miss it (intentionally or otherwise) how would the mapping happen?

Well, when the value is not given, we would assume that probably it would try to match the sys_id of that reference field while trying to associate the reference field during the runtime transformation, but that's not the case- in fact the reference table's display value that is used for a match or association, which would mostly be the number or the name of the record...

FYI, heads-up, you've been warned!

[CharanV98428402]

Hi @Wasif 

You can refer to this Knoledge artical below

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0994849

If this answer helps you in any way make sure to Mark this as accepted solution and give a thumbs up.

Regards

Charan

[Sreeram Nair]

This is what I normally do to ensure reliability: you can preprocess the import data to align reference values with unique identifiers before transformation. Another approach is to use a Scripted Transform Map or onBefore script to perform precise lookups (e.g., using GlideRecord queries to find the correct reference record).