Using TRCS data management or data exchange to load no data or #missing instead of zero

Summary:

Colleagues need to use data management to clear previously entered data in Tax Reporting Cloud Sevrice (TRCS). Currently they are using a zero which takes up database, so instead we want to be able to submit either "no data" or #missing.

Content (please ensure you mask any confidential information):

We have seen the following import format expression in SR4-0003033702

IF ([DataColumn] = "#missing" OR [DataColumn] = "nodata") THEN    SET [DataColumn] = MISSING_VALUE_REPRESENTATION;ELSE    SET [DataColumn] = [DataColumn];END IF;

However, it is erroring out, or ignoring the one row which we are testing.

Version (include the version you are using, if applicable):