Data Center
  • Data Center
    • Homepage
    • Data Connectors
      • Create 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
          • Athena
          • 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
          • Sharing a Data Set
          • Publishing a Data Set
          • Push to VCS
          • Pull from VCS
          • Deleting a Data Set
          • Data Preparation
    • Data Stores
      • Creating a New Data Store
        • Data Store using an RDBMS 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
        • Refresh Synonyms
        • Push to VCS
        • Pull from VCS
        • Delete a Data Store
    • Data Store Meta Data
      • Creating a New Meta Data Store
      • Data Store Meta Data List
        • Editing Meta Data Store
        • Store Details
        • Adding Synonyms to Meta Data Store
        • Refresh Synonyms
        • Sharing a Metadata Store
        • Deleting Meta Data Store
    • Data Sheets
      • Creating a New Data Sheet
      • Editing a Data Sheet
      • Publishing a Data Sheet
        • Entering Data
        • Applying Filter
        • Deleting a Row
      • 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
        • Create Data Store
        • Reupload
        • Preview
        • Create Datasheet
    • Data as API
    • Data Preparation
      • Accessing the Data Preparation Option
      • Data Preparation Workspace
        • Data Preparation Landing Page
        • Profile Tab
        • 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
  1. Data Center
  2. Data Sheets

Creating a New Data Sheet

PreviousData SheetsNextEditing a Data Sheet

Last updated 8 months ago

Check out the given walk-through on how to create a Data Sheet.

  • Navigate to the homepage of the Data Center module.

  • Click the Data Sheet option from the New Context menu.

  • The Data Sheet Connector page opens.

  • Provide a name for the Data Sheet.

  • Provide the following information:

    • Column Name: Provide column names as per the data source.

    • Input Type: Select an option out of the provided choices. (text/numeric/dropdown/autocomplete/checkbox/radio/calendar).

    • Look Up: This option is enabled only when the input type is dropdown. In this option, we select the datasheet whose value has to be listed in the dropdown.

    • Column: This option is enabled only when the input type is dropdown. In this option, we select the datasheet column (selected in Look Up) whose value has to be listed in the dropdown field.

    • Data Restriction: Defined Custom Fields get listed in the drop-down menu.

    • Filter: Enable the filter by putting a checkmark in the given box.

    • Add/Update: To add a new column/ Modify an existing column.

    • Delete: To remove the added Column in the Data Sheet.

  • By clicking the Add/Update option a new column gets added/to an existing column gets updated based on the entered details under the Data Sheet Preview space as displayed in the given image.

  • The Save option gets enabled which the user can click to save the Data Sheet.

  • A success message appears.

  • The newly created Data Sheet gets added to the Data Sheets list.

Please Note:

  • Click the Refresh icon to refresh the Column design fields. The data in the design area gets cleared.

  • Click the Delete icon to delete the selected column.

Creating a New Data Sheet
Accessing the Data Sheet option
A newly created Data Sheet get added to the Data Sheet List