3570130 - Unable to delete entries from column of a import job of model in SAP Analytics Cloud (SAC)

The transformation to delete "false" value from a column using expression "contains", is not working correctly in Data Import option of Planning Model in SAC

SAP ANALYTICS CLOUD 2024.21.14

1. Login to SAC
2. Open a model
3. Switch to Data Management workspace 
4. Start an Import Job->Set up Import
5. In "Prepare Data" view create an expression [Column1] = contains([Column2], "Value"]
6. Try to delete the rows containing "false" from column "Column1".
   
   Note: The rows are not deleted even though success message is shown.

According to "Custom Expression Help", "contains" returns either 1 or 0, instead of "true" or "false"

1. Select the column "Column1" and click on "Create a Transformation".
2. Select Filter
3. Filter values in [Column1] not matching "0"

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
  • https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
  • Note: Add relevant text or warning/error messages to the text search field to filter results.

• Apply Data Transforms to Cells, Rows, and Columns in Datasets | SAP Help Portal

• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

SAP Analytics Cloud, SAC, import, expression, contains, data transformations , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem