I am working with Anaplan Data Orchestrator (ADO) and trying to transform uploaded data by adding a new column and concatenating several columns to create a unique key.
However, some cells in these columns are empty. When this happens, ADO returns the entire concatenated key as NULL instead of using the values available in the other columns. I also tried using the NVL function, but it did not work.
Could anyone please guide me on how to handle the empty/NULL values and create the unique key correctly?
