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. Connect to Data
  3. Configuration Steps

Configure Type 2 SCDs (Optional)

PreviousConfigure ColumnsNextCreate a Table

Last updated 6 months ago

In the final step, you can configure the visual to support Type 2 Slowly Changing Dimensions.

Type 2 Slowly Changing Dimension (SCD) is a data warehousing method to track changes in data over time by preserving the change history.

Understanding Type 2 SCDs

-> When a value in a dimension (such as customer information) changes, a new record is created instead of overwriting the old data.

-> Each new record includes the updated information along with the start and end dates indicating the validity period of the updated information.

-> There can be an additional flag column that indicates the record is currently active. This column can be of the checkbox type, or a simple true/false or 0/1 column.

-> There can also be additional timestamp columns to signify when a new record was created or made active apart from the initial start date.

This approach allows us to analyse the historical data and understand how the information has evolved over time.

For more details on SCDs and their types, click.

We will now look at the overview:

  1. To configure SCDs, click on the link as shown in the image below:

  1. Enable support for SCDs and configure them.

  1. If you do not wish to enable support for Type 2 SCDs, simply click Save without enabling the toggle button as below.

  1. The action of configuring SCDs is permanent and cannot be undone once enabled and saved.

  2. If you have missed configuring SCDs and wish to set it on a later date or you need to edit the existing configuration, you will need to reset all the visual settings by clicking on Reset in the Settings window. Note that this resets all the settings, including the source and column configurations.

  1. After configuring all the required settings, you can close the 'Settings' tab by clicking Close Settings or by directly navigating to the Home tab. EDITable displays the connected source table as below:

EDITable also supports creating a table from scratch or importing it from spreadsheets. These steps are explained in the next section.

We have a detailed section that explains how to configure type 2 SCDs in EDITable and you can access it .

After configuring the source data, you are good to go with managing and updating your data with EDITable. You can jump to to know more.

here
this section
here
Review optional settings - Configure SCDs
Configure SCDs
Save without enabling SCDs
Source