SAP Knowledge Base Article - Public

3538113 - Unable to add additional columns to an existing dataset using the reimport option in SAP Analytics Cloud(SAC)

Symptom

Unable to add additional columns to an existing dataset using the reimport option in SAP Analytics Cloud.

Environment

SAP Analytics Cloud (2024.15.11)

Reproducing the Issue

  1. Log in to the SAC.
  2. Navigate to the dataset section.
  3. Create a new dataset by uploading an Excel file.
  4. Save the newly created dataset.
  5. Add a new column to the original Excel file.
  6. Attempt to re-import the updated Excel file into the existing dataset.
  7. Observe that you are unable to import the updated Excel file.

Cause

This behavior is by design.

Resolution

Currently reimporting a file for an existing dataset only support the case that the new file and the origin file have the same columns (number of columns and column names): Reimport Data into a Dataset | SAP Help Portal

You can create influence request to request this feature for upcoming product enhancement: 

2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud?

See Also

Keywords

SAP Analytics Cloud, reimport dataset, add columns, error message, Excel file, dataset update, compatible file, SAC dataset limitations , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions