Issue Summary

Because of https://jira.atlassian.com/browse/JSDCLOUD-19326, Data Manager treats (Empty) and (null) as two distinct value types, and the "NULL values: Remove" setting in the Import Structure currently only clears text/string attributes — it does not clear object reference attributes (i.e., attributes whose value is linked to another object). The (Empty) representation in sandbox does clear object references, which is why behaviour differs between environments.

Steps to Reproduce

1. Prepare a CSV file containing user object data with intentionally empty cells for columns that map to object reference attributes (i.e., attributes linked to another Assets object).

1. In Data Manager, create a new import using the CSV on both a sandbox site and a production site with identical configurations.

1. In the Import Structure, set:

• • Empty values → Remove

• • NULL values → Remove

1. Run the Import step on both sites using the same CSV file.

1. Run the Cleanse step on both sites.

• • Observe that empty cells display as (Empty) in sandbox and (null) in production.

1. Run the Merge step on both sites to push data into the Assets object class.

1. Navigate to the affected Assets objects on both sites and inspect the object reference attributes that corresponded to empty CSV cells.

Expected Results

When both "Empty values: Remove" and "NULL values: Remove" are configured in the Import Structure, all empty CSV cells — regardless of whether they are represented as (Empty) or (null) — should clear object reference attributes during merge, consistent with the behaviour observed in sandbox environments.

Actual Results

In production, empty CSV cells are represented as (null) after the cleanse step. During merge, (null) values do not clear object reference attributes even when "NULL values: Remove" is enabled. The same CSV and identical import settings in a sandbox environment represent empty cells as (Empty), which does correctly clear object reference attributes during merge.

Workaround

No workaround as of now