cancel
Showing results for 
Search instead for 
Did you mean: 

Append new data to model with calculated columns in SAP Analytics Cloud

0 Kudos

I created a model from an Excel file and in it I added a calculated column (substring formula).

Now I need to import new data with append method but I can not complete model creation because calculated column is not mapped.

Do you have any advice for me? Thanks a lot in advance and best regards

Accepted Solutions (0)

Answers (2)

Answers (2)

saurabh_sonawane
Active Contributor
0 Kudos

Hi,

try to assign a default value to that calculated field.

OR

try to use a combined data option in the data wrangling stage so you can combine ur excel file and import data together.

Thanks,

Saurabh S.

William_Yu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi ams.accenture,

I believe you need to repeat the cacluation column with substring formula in data wrangling and map it to the dimension in your existing SAC model.

Best regards, William