xMart logo xMart Docs
Pipeline Script Guide | Back to site ⤴
  • General
    • Overview of xMart
    • Navigate to mart
    • Architecture of xMart
  • Tutorials
    • 1. Simple REPLACE
    • 2. Simple MERGE
    • 3. Model Validation
    • 4. Custom Business Rules
    • 5. Global Transformations
    • 6. Table-Specific Transforms
    • 7. Foreign Keys
  • Release Notes
    • Version 4.34
    • Version 4.33
    • Version 4.32
    • Version 4.31
    • Version 4.30
    • Version 4.29
    • Version 4.28
    • Version 4.27
    • Version 4.26
    • Version 4.25
    • Version 4.24
    • Version 4.23
    • Version 4.22
    • Version 4.21
    • Version 4.20
    • Version 4.19
    • Version 4.18
  • How Tos
  • Data Catalog
    • Create Categories
  • Data Editing
    • Read Data
    • Edit data in UI
    • Download Data
    • Upload data from Excel
  • Data Loading
    • Data Load Page
    • Exclude some rows
    • Ignore Lookup Issues
    • Notifications
    • Export Staged Data
    • Resolve Lookups
    • Schedule a Load
    • Simple Upload Page
  • Data Modeling
    • How to create tables
    • Data Modelling Basics
    • Best Practices
    • Edit model via Excel template
    • Data to model
    • Edit model via UI
    • Creating a Model from SQL Server
    • Computed Field Type
    • Hard Delete Tables and Fields
    • Change FK Table
    • Centralized Validation Rules
    • Archive Retention Period
  • Pipelines - Basics
    • Introduction to Pipelines
    • Writing Normal Pipelines
    • Use Variables
    • Test and debug a pipeline
    • Set up batch approval
  • Pipelines - Extract
    • List of Extracts
    • Process Data View Rows
    • Call ArcGis API
    • Call DHIS API
    • Call Excel Online (via Graph Explorer)
    • Call GoogleSheet API
    • Call ODK Central API
    • Consume Excel file stored on SharePoint Site
    • Consume data from a SharePoint List
    • Consume data from SFTP
    • Consume data from MS Word Forms
  • Pipelines - Transform
    • List of Transforms
    • Country to ISO3 / M49
    • Use the HierarchyLookup command
    • Resolve Lookups in UI
  • Pipelines - Flow
    • Writing Flow Pipelines
    • Sync Files with FilesFrom* Commands
  • Data Forms
    • Data Entry Forms
    • Standard Forms
    • Custom Forms
    • SubForms
  • Custom Views
    • Create Custom Views
    • SQL FAQs
    • Optimize Custom Views
    • Custom Views in xMart UI
  • Xmart Api
    • Introduction to xMart API
    • OData API
    • Trigger Pipeline API
    • Register client app
    • Consume OData in Postman
    • Consume OData in R
    • Consume OData in Excel
    • Consume OData in PowerBI
  • Security
    • Security Overview
    • Create Roles
    • Add Users
    • List of Permissions
    • Choose Active Roles
    • Row-level Security
  • Deploy
    • Export Mart
    • Import Mart
  • Mart Admin
    • Mart Tab
    • Truncate a Table
  • Sys Admin
    • Write a HowTo
    • Mart Tasks

How to create tables

Creating tables is normally done in one of the following ways:

  1. editing an Excel file
  2. editing via the UI using the Model Page Editor.
  3. editing via the UI using the Gridview Editor.
  4. from existing data using the Data to Model feature
  5. extracting the xMart table definition using a query from a SQL Server database.

If you are creating the model yourself, it’s a good idea to read Best Practices and Data Modelling Basics.

Jump to Section