I'm trying to import some data that includes information about a tax declaration. The raw data in my file (xlsx) says Yes, No or Unknown.
When I go to IOM> Configuration> Profile> Test Code it reads the data as Yes, No or Unknown as per the raw file however when I actually import this into RE it imports every single declaration as Yes.
This is a massive issue as we're now potentially flagging people as paying tax & eligible for Gift Aid claims when they are not.
nvm - after 2 days looking a colleague took 5 minutes and pointed out where I was being silly