SAC - Updata data loaded from local file

[egil63]

Hello, 

with  a job I added in my SAC model,  data from local file ( like a budget) , and protect the data loaded again transactional  data from SAP .

like 

DATE, CUSTOMER ID ,NAME , FUNCTION PARTNER, QTY, VALUE

Now I need to update Function partner based on what I have in transactional data because si changed in SAP.

I don't want to create a new job, map and transform data, validate etc.

If there a way to update these data with  ( stupid example) update ..from ..where ? 

Kind regards

Gildo 

[Yogeshwar_M · Accepted solution]

Hi @egil63,

In SAP Analytics Cloud you can create an upload job in the model. Once the upload job is set up, there's no need to map it repeatedly. Simply maintain the Excel file according to the upload job requirements.

In the story, you can upload the Excel file directly and publish the data.

If you find this helpful, kindly upvote!

Thank you.

[egil63 · Accepted solution]

Hi @Yogeshwar_M, tks for your solution, that can solve my problem.

[William_Yu1]

If you don't want to redo the mapping and wrangling, you can simply use 'Replace data source' option of import job in data management( of new model). 

Or you may also consider to use the new file upload widget to load data from local file in story directly. For more details, please refer to this blog: https://community.sap.com/t5/technology-blogs-by-sap/new-end-user-file-upload-in-sap-analytics-cloud...