Upload Data
  • 30 May 2022
  • 1 Minuto para leer
  • Oscuro
    Ligero
  • PDF

Upload Data

  • Oscuro
    Ligero
  • PDF

The content is currently unavailable in Spanish. You are viewing the default English version.
Resumen del artículo

Upload Data to Master Tables

Data Operators

Data Operators have the right to add data to assigned Master Tables. The Master Tables access for Data Operators is provided by the Operator, also known as the Admin.

To upload data to Master Tables, follow the sequence below:

  1. Log in to the platform.

  2. The Master Table page is the only section available on the Navigation Panel.

  3. A list of all the accessible Master Tables appears on the screen.

  4. Locate the required Master Table and click on it.

Upload Button

Note: An Upload button is seen for a Data Operator account.

Master table view.png

  1. Click on the Upload button on the top right corner.
    Image16.png

  2. The Upload sidebar appears on the right.
    Image17.png

Upload Instructions

The Upload sidebar has vital information about uploading data on master tables.
• Making changes in the data may impact the calculations.
• Please upload verified and correct data only.
• Duplicate entry is not allowed. Please check the input file for duplicate entries.
• Please check the file for the overlapping date ranges and remove any discrepancies before uploading.
• Row versions will be maintained for the same key values.
• The maximum file size is 10 MB.

  1. Click on the Download Template link.
  2. An Excel Worksheet is saved on the computer. Locate and open the Excel Worksheet.
Master Table Template

The Excel Worksheet, also known as the Master Table Template, is saved with a platform-generated name. A sample name would be Template-1635944512312 - A prefix of ‘Template’ followed by a series of numbers.
The Master Table Template contains all the columns present on the Master Table on the platform.

Master Table Template .png

  1. Fill in the values on the Master Table Template for the respective columns. Once the data is updated, save the template.
NOTE:

Remember to close the Master Table Template worksheet before uploading it on the platform.

  1. Click on the Upload area on the Upload sidebar. As the instruction states, drag and drop a file to upload it on the platform.

  2. Once the Master Table Template is uploaded, the Upload button on the bottom right of the sidebar is enabled.

Upload-Data-to-Master-Tables-05.png

  1. Click on the Upload button to successfully add data to the Master Table.

¿Te ha sido útil este artículo?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.