3631314 - Error: "failed to execute transform" when using null in IF formula in import job - SAP Analytics Cloud

• SAC import connection, when "Prepare Data", if set formula using "null", for example below formulas, get "failed to execute transform":
• [Column] = IF( 1==1, 1, null )
• [Column] = IF( 1==1, "1", null)
• The issue happens since 10.07.2025.
• After this issue happens, existing job which used this formula cannot run or be edited anymore.
• Error message: "failed to execute transform"

• SAP Analytics Cloud (SAC) 1.0

1. Create a new import job. Import a csv data or database data.
2. Click Set Up Import.
3. In "Prepare Data", create a transform on an Account column or other column.
4. Edit the formula like [Column] = IF( 1==1, 1, null ), or [Column] = IF( [Column]==1, 1, null ), then Click Check button to apply the formula. get "failed to execute transform" error.
5. Below workaround is found when creating new job, however, existing job still fail since cannot edit existing job:

• [NullColumn] = null
• [Column] = IF( 1==1, 1, [NullColumn] )
• [Column] = IF( 1==1, "1", [NullColumn] )

The solution of this issue is currently under investigation.

The solution of this issue is currently under investigation. Please follow this KBA for updates.

Refer to: Null Values for Date Dimension Rejected when importing data in a Model in SAP Analytics Cloud (SAC)

Refer to: SAP Note 3584714

failed to execute transform, SAC, import connection, prepare data, null formula, data acquisition, BW, error message, existing job, new job, workaround, SAP Analytics Cloud , KBA , LOD-ANA-AQU-BW , Data Acquisition from BW , LOD-ANA-ML-DE , SAC Data Wrangling , Problem