EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Parameters Explained: mstrio for Python - Update Dataset


Community Admin

• Strategy


This article explains what each parameter is in the update_dataset () function of mstrio for Python.

Updating datasets in Strategy with Python requires the update_dataset () function from the mstrio Python package.  This function has 4 required parameters and no optional parameters.
Required:

  • Dataframe - this is a Pandas dataframe to use to update an in-memory dataset
  • Dataset ID - string identifier of the dataset to update. Provided by create_dataset ()
  • Table Name - this is a string object with the name of the table in the dataset to be updated
  • Update Policy - string object with the update operation to perform. One of 'add' (inserts new, unique rows), 'update'
    
    (updates data in existing rows and columns), 'upsert' (updates existing
    data and inserts new rows), 'replace' (similar to truncate and load, replaces the existing data with new data).

KB442244


Comment

0 comments

Details

Knowledge Article

Published:

November 13, 2018

Last Updated:

November 13, 2018