Inforiver
EDITable
EDITable
  • Introduction to EDITable
    • Why EDITable?
    • Supported Database Connections
  • Get Started
    • EDITable Pre-requisites
      • Admin consent for EDITable's Entra ID
        • Basic consent
        • Full admin consent
    • Install EDITable
    • Add EDITable visual
  • Getting Data into EDITable
    • Connect to Data
      • Get data
      • Assign fields
      • Configuration Steps
        • Configure source
        • Configure Columns
        • Configure Type 2 SCDs (Optional)
    • Create a Table
      • Create From Scratch
      • Use Existing Table
      • Import Data
  • Working with EDITable
    • EDITable interface
    • Manage Columns
      • General
      • Constraints
      • Lookup and Relation
      • Display
      • Import/Export Configuration
      • Add Database Column
      • Insert Column
    • Column Access Control
    • Row Identification
    • Table Operations (Insert/Update/Delete)
      • Edit data
      • Bulk Edit
      • Find and Replace
      • Insert rows
      • Insert Column
      • Import rows
      • Delete rows
      • Duplicate rows
      • Copy rows
      • Preview Changes
      • Reset Changes
    • Explore data
      • Search and filter
      • Sort and reorder
      • Show/Hide columns
      • Pin columns
      • Group Rows By
      • Summarize Column
    • Basic formatting
    • Conditional Formatting
  • Row Access Control
  • Approval Workflow
    • Review Changes - Workflow process
  • Type 2 SCDs
    • Configuring Type 2 SCDs in EDITable
  • Audit logs
  • Webhook
  • Display Settings
  • Commenting and Collaboration
    • Assign users & task status
    • View all comments & track changes
    • Comment Settings
  • Admin Portal & EDITable Console
    • Tables
    • Transaction Logs
    • Insights (Metrics)
    • Utility
      • Download Report
      • Pipeline
        • Power BI & EDITable deployment pipelines
        • Deployment in different destinations
        • Trigger deployment pipeline from external applications
        • Logs & other pipeline options
    • Manage Profile
    • Admin Portal
      • User Management
      • Settings
        • General Settings
        • Writeback Settings
          • Settings
          • EDITable managed DB
        • API token
    • Onboarding Actions
  • Formula and Functions
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEIF
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • LOG
      • MAX
      • MIN
      • PCT
      • POWER
    • Text formatting functions
    • Date functions
      • DATE
      • DATE.FORMAT
    • Other operators
  • Keyboard Shortcuts
  • Release Notes
    • EDITable - v1.7.5
    • EDITable - v1.7
    • EDITable - v1.6.5
    • EDITable - v1.6
Powered by GitBook
On this page
  1. Getting Data into EDITable
  2. Create a Table

Create From Scratch

PreviousCreate a TableNextUse Existing Table

Last updated 5 months ago

This section explains the steps to create a table from scratch.

  1. Select the option as shown below and then click Continue.

  1. The 'Create Table' pop-window opens where you can specify the required details.

  1. Table Name: Enter a name for your table.

  1. Column Details: Start creating your table by adding the column name, primary key, and other relevant details like length, precision, etc. wherever applicable.

  1. Add Column: Click on '+ Add Column' at the top of the 'Column Details' table to add a new field/column.

  1. Advanced Properties: Check this option to add advanced properties to the column such as Display Name, Thousands Separator, Prefix and Suffix.

  1. Click the bin icon as shown below if you want to delete that column.

  1. You can click on Preview if you wish to view the SQL query generated which will be used to create a new table in the chosen destination.

  1. Click Apply after entering all the column details.

You can now download a pre-configured Power BI report (.pbix file) with a live connection to the table.

After downloading the .pbix file, you might get a few pop-up messages:

  • Click 'Apply changes' to apply any pending changes to the queries.

  • Close the 'Pause visuals' suggestion tip that appears below. Do not pause the visuals so the live changes get synced to the database.

  • Save the .pbix report at regular intervals after making any changes to avoid loss of data.

If you already have an existing database, you can directly connect to it and start working on it. This is explained in the next section.

Select Connection: Choose from the list of admin or user connections, or . The supported database connections are mentioned .

If you do not want to choose any of the existing connections and would like to add a new connection, click on Add Connection. To learn more on adding a connection, refer to .

After creating a table, you can proceed to the next step: , to configure them, and then you can start working on your data.

EDITable managed DB
here
this page
managing columns
Create From Scratch
Create Table
Select connection
Add connection
Table name
Add Column details
Add Column
Advanced Properties
Delete a column
Preview Query
Click 'Apply'