Transform Map Row has Different Value for Active column from Loaded excel sheet

[Anil_T]

Whenever I am loading the excel file for Control Objective records with Active column, System is Showing different value for Active on Import Set row with "TRUE" and "true".

When system marks Import set row with Active as "TRUE" then control objective got deactivated and when system marked Import set row with Active as "true" then control objective got activated.

Can you please let me know whether this is the System configuration issue or the Sheet we are loading.

Note: When system marked Active as "true" at that time before uploading the sheet, I cleared the existing value on active column and added back true value in the sheet

[Anil_T]

Hi @Ankur Bawiskar ,

Thanks for the response.  the mentioned property is  not there in our customer instance. Even if the property is not there, does still impact the system how it reads True/False data?

[Ankur Bawiskar]

@Anil_T 

you can use field map script and convert it to true/false and then set

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