Data Center
  • Data Center
    • Homepage
    • Data Connectors
      • Creating a Data Connector
      • Data Connector List
        • Edit Data Connectors
        • Create Option
        • Reconnecting to a Data Connector
        • Sharing a Data Connector
        • Delete a Data Connector
      • Supported Data Connectors
        • Database Connectors
          • MySQL
          • MSSQL
          • Elastic (Beta Release)
          • Oracle
          • ClickHouse
          • Arango DB
          • Hive
          • Cassandra
          • MongoDB
          • MongoDB for BI
          • PostgreSQL
          • Snowflake
        • File Data Connector
        • API Connectors
          • API Connector
          • Amazon
          • App Store
          • Bing Ads
          • Dropbox
          • FTP Server
          • Facebook
          • Facebook Ads
          • Firebase DB
          • Fitbit
          • Flipkart
          • Google AdWords
          • Google Analytics
          • Google Big Query
          • Google Forms
          • Google Sheet
          • HubSpot
          • Jira
          • Lead Squared
          • Linkedin
          • Linkedin Ads
          • MS Dynamics
          • Mailchimp
          • QuickBooks
          • SalesForce
          • ServiceNow
          • Twitter
          • Twitter Ads
          • Yelp
          • YouTube
          • ZOHO Books
        • Others
          • MS Sql Olap
          • Data Store
          • OData
          • Spark SQL
          • AWS Redshift
          • SAP HANA
    • Data Sets
      • Creating a New Data Set
        • Creating a New Data Set using RDBMS Connector
        • Creating a Data Set using Arango DB Connector
        • Creating a Data Set using an API Connector
        • Creating a New FTP Data Set
        • Creating a Data Set based on an Elastic Connector
      • Data Set List
        • View Options: Data Sets List Page
        • Data Set List: Actions
          • Editing a Data Set
          • Publishing a Data Set
          • Sharing a Data Set
          • Push to VCS
          • Pull from VCS
          • Deleting a Data Set
          • Data Preparation
          • Visualize
            • Deleting a Widget
    • Data Stores
      • Creating a New Data Store
        • Data Store using an RDBMS Connector
        • Data Store using a Flat File Data Connector
        • Data Store using an API Data Connector
      • Data Stores List
        • Edit a Data Store
        • Refresh Data for a Data Store
        • Store Info
        • Sharing a Data Store
        • Adding Synonyms to a Data Store
        • Push to VCS
        • Pull from VCS
        • Delete a Data Store
        • Visualize
          • Deleting a Widget
    • Data Store Meta Data
      • Creating a New Meta Data Store
      • Data Store Meta Data List
        • Store Details
        • Adding Synonyms to Meta Data Store
        • Refresh Synonyms
        • Sharing a Metadata Store
        • Editing Meta Data Store
        • Deleting Meta Data Store
    • Data Sheets
      • Creating a New Data Sheet
      • Publishing a Data Sheet
        • Entering Data
        • Viewing Data
        • Deleting a Row
      • Editing a Data Sheet
      • Removing a Data Sheet
    • Data Sandbox
      • Creating a New Data Sandbox
      • Data Sandbox List
        • Upload File Status
        • Using the Data Preparation Option
        • Deleting a Data Sandbox
        • Visualize
          • Deleting a Widget
        • Create Data Store
        • Reupload
    • Data Catalog
    • Data as API
    • Data Preparation
      • Accessing the Data Preparation Option
      • Data Preparation Workspace
        • Data Preparation Landing Page
        • Profile: Summary Pane
          • Charts
          • Info: Values/Statistics
          • Pattern
        • Transforms
          • Advanced
          • Anonymization
          • Columns
          • Conversions
          • Data Cleansing
          • Dates
          • Functions
          • Integer
          • ML
          • Numbers
          • String
        • Steps
      • Data Preparation List
        • Rename
        • Edit
        • Delete
Powered by GitBook
On this page
  • Manual Entering
  • Copying and Pasting Data into a Published Data Sheet
  1. Data Center
  2. Data Sheets
  3. Publishing a Data Sheet

Entering Data

PreviousPublishing a Data SheetNextViewing Data

Last updated 1 year ago

Manual Entering

  • Open a published Data Sheet.

  • Click the Add Row icon.

The Add Row icon for a published Data Sheet

  • A new row gets added at the bottom (the given image displays 2 rows added to the Data Sheet.

  • Manually add the data in the rows.

  • Click the Save icon.

  • The added data gets saved in the Data Sheet.

​Please Note: Fill in the value for each column and click the save icon to save the data.

Copying and Pasting Data into a Published Data Sheet

The user can create a meta-structure of the Data Sheet using the Data Center module and later insert data from an excel file. The user can directly copy and paste data to the published Data Sheet.

  • Access the published Datasheet from My Documents.

  • Click on it to open.

  • Meta Structure of the selected Data Sheet opens.

  • Click the Add Row icon.

  • A new row gets added.

  • Copy the required Excel data.

  • Paste it to the Data Sheet metadata structure.

  • Click the Save icon to save the copied data.

  • The copied data from the excel sheet gets saved to the Data Sheet.

The new rows get added at the bottom
Selecting a Data Sheet
Meta Data structure of the Data Sheet
Adding a new row to the Data Sheet meta data

​

Pasting the Excel data in the Data Sheet
The copied data gets pasted to the Data Sheet