Transform map issue

[MS12345]

Hello team,

I have created a standard Transform Map and imported an Excel file. Although the Excel file does not contain a value for the Model ID field, the transformed records are being populated with "Unknown" as the Model ID.

Could you please advise on how to prevent the Model ID from being set to "Unknown" when no value is provided in the source file?

Tried adding onbefore script aswell...still its not working 

Regards,

Suhail

[Ankur Bawiskar]

@MS12345 

things to check

1) any default value for that field at dictionary level

OR

2) any before insert Business rule is setting that

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏