Skip to Main Content

Transformation in Data Load Definition in Oracle Apex 22.1.6

Annamalai VDec 5 2022

I am using Oracle Apex 22.1.6 for creating a data load definition in order to create a data loading page.
I have one column in the source file and that is the primary key column and it can be null sometimes in the source file. Since it is a primary key column, it should always have some value while loading into the table.
Either I can use the NVL function anywhere in the data load definition or I can use some transformation rule type to achieve this. Please suggest me the best way to do that.
Please let me know how I can transform this column to have some default value whenever it is null.
Thanks & Regards,
Annamalai V.

Post Details
Added on Dec 5 2022