Tabula Documentation
Tabula HomeCommunity
  • 👋Introduction to Tabula
  • Getting Started
    • Product Updates
    • Getting Started
      • Installation and Login
      • Beginner's Guide
    • FAQ
  • Product overview
    • Home Page
    • Exploring Data
      • Data Catalog
      • Exploring Datasets
      • Statistics Panel
    • Designing Flows
      • Creating Flows
      • Flow Designer Guide
        • Working with Canvas
        • Using Groups
        • Working with Table
      • Managing Flows
      • Sharing Flows
      • Demo: Building a Simple Flow
    • Executing Flows
      • Running Flows
      • Jobs overview
    • Building Reports
      • Designing Reports
      • Running Reports
      • Reports Page
    • Connecting Data
  • Integrations
    • Enrichments
      • How to add your API key in Tabula
      • List of Supported Queries
      • Enrichment Providers
        • AnymailFinder
        • Apollo
          • How to find Apollo API key
          • Enrich person by LinkedIn
          • Enrich company by domain
        • Bounceban
        • Bouncer
        • Bouncify
        • CaptainVerify
        • Cleanify
        • Clearout
        • CompanyEnrich
        • ContactOut
          • How to find ContactOut API key
          • Enrich person by LinkedIn
          • Enrich person by email
        • Discolike
        • TheCompaniesAPI
        • Findymail
        • Emailable
        • EmailListVerify
        • Enrichley
        • Heybounce
        • Hunter
        • Kickbox
        • Mails
        • MailChecker
        • MillionVerifier
        • NeverBounce
        • Nubela (Proxycurl)
        • PeopleDataLabs
        • Prospeo
        • ZeroBounce
        • ReverseContact
          • How to find Reverse Contact API key
          • Enrich person by LinkedIn
          • Enrich person and company by email
          • Enrich company by domain
          • Enrich company by LinkedIn
        • UpLead
    • Data Sources
      • Configuring Fivetran Integration
    • Data Storages
      • PostgreSQL
      • Snowflake
      • BigQuery
      • ClickHouse
  • Data Transformation
    • Transforms
      • Source
      • New Empty Table
      • Output
      • Chart
      • Enrichment
      • New Column
      • If...Then
      • Rolling Functions
      • Column Type
      • Columns Edit
      • Filter
      • Remove Duplicates
      • Sort
      • Find and Replace Text
      • Split Column
      • Extract Text
      • Match Text
      • Join
      • Union
      • Group By
      • Pivot
      • Unpivot
      • To JSON
      • From JSON
      • API Call
      • AI Column
      • AI Table
    • Formulas
      • What are Formulas?
      • Math Functions
        • Abs
        • Ceiling
        • Exp
        • Floor
        • IsEven
        • IsOdd
        • Ln
        • Log
        • Log10
        • Mod
        • Pi
        • Power
        • Quotient
        • Round
        • RoundDown
        • RoundUp
        • Sign
        • Sqrt
        • Truncate
      • Trigonometric Functions
        • Acos
        • Asin
        • Atan
        • Atan2
        • Cos
        • Cot
        • Degrees
        • Radians
        • Sin
        • Tan
      • String Functions
        • Compare
        • Concat
        • Contains
        • In
        • CountMatches
        • CountMatchesRegexp
        • EndsWith
        • EndsWithRegexp
        • Extract
        • FindMatchOfString
        • FindMatchOfRegexp
        • FindMatchesOfString
        • FindMatchesOfRegexp
        • Left
        • Length
        • Lower
        • Matches
        • Pad
        • ProperCase
        • RemoveSymbols
        • RemoveWhitespaces
        • Repeat
        • Replace
        • ReplaceRegexp
        • Reverse
        • Right
        • Spaces
        • Split
        • SplitRegexp
        • StartsWith
        • StartsWithRegexp
        • Stuff
        • Substring
        • SubstringDelimiter
        • SubstringRegexpDelimiter
        • Trim
        • Upper
      • Date & Time Functions
        • Date
        • DateAdd
        • DateAdd2
        • DateDiff
        • DateDiff2
        • DateFromParts
        • DateTime
        • DateTimeFromParts
        • DateTrunc
        • DayName
        • DayOfMonth
        • DayOfWeek
        • DayOfYear
        • Hour
        • Minute
        • Month
        • MonthName
        • Now
        • Quarter
        • Second
        • Time
        • TimeFromParts
        • Today
        • Week
        • Year
      • Aggregate Functions
        • Any
        • AnyIf
        • Array
        • ArrayIf
        • Avg
        • AvgIf
        • AvgInRow
        • Count
        • CountA
        • CountIf
        • CountUnique
        • Max
        • MaxIf
        • MaxInRow
        • Median
        • MedianIf
        • Min
        • MinIf
        • MinInRow
        • Mode
        • ModeIf
        • Percentile
        • Quartile
        • StdDev
        • StdDevIf
        • Sum
        • SumIf
        • SumProduct
        • Variance
        • VarianceIf
      • Conversion Functions
        • ToArray
        • ArrayToString
        • ToBoolean
        • ToDate
        • ToDateTime
        • ToDecimal
        • ToInteger
        • ToObject
        • ToTime
        • ToString
      • Misc Functions
        • At
        • IsMissing
        • RowNumber
        • Random
        • If
        • Coalesce
        • True
        • False
        • Null
        • $target
      • Window Functions
      • Custom Functions
      • Data Types
      • Supported Date Parts
      • Regex: List of Tokes
  • Pricing & Billing
    • Plans, Subscriptions, and Credits
    • Tabula for Education
  • Tutorials
    • Tabula Use Cases
    • Merge Columns
    • Join Types
    • Union Introduction
    • Window Functions
    • What is Unpivot?
    • JSON Format Tutorial
    • Using Regex
Powered by GitBook
On this page
  • Overview
  • Settings
  • Create manually
  • Ask AI

Was this helpful?

  1. Data Transformation
  2. Transforms

New Empty Table

Adds empty table to the flow, you can manually add and edit data.

Last updated 1 year ago

Was this helpful?

Overview

The Empty Table Node offers a straightforward way to manually input data directly into your workflow. An empty table interface appears when you add this node onto your canvas, allowing you to type in your data or paste it from your clipboard. This feature is particularly useful for incorporating ad-hoc data, running quick tests, or supplementing existing data sets.

Settings

You have two options for creating a table.

Create manually

Adding and removing rows and columns

To add and remove rows:

  • Use the Rows fields in the right panel to specify the desired number of rows.

  • Use the + icon after the last row in the table to add a new row.

  • Press "Enter" after editing any cell in the last existing row to add a new row.

  • Select "Insert row above" or below options in the context menu (right-click over a row number)

  • Select "Duplicate row" in the context menu

  • Select "Delete" in the context menu to remove the row.

To add and remove columns:

  • Use the Columns fields in the right panel to specify the desired number of columns.

  • Use the "+ Add" and "X" buttons near the column list in the right panel to add or remove a new column, respectively.

  • Use the + icon after the last column header in the table to add a new column.

  • Select Insert left or right options in the context menu (right-click a column header)

  • Select "Delete" in the context menu to remove the column.

Rename and set type for columns.

Now we support a restricted number of types: String, Integer, Decimal, Boolean, Date, DateTime, Time.

  • Use the right panel to set names and types

  • Double-click on the column name in the table header to rename the in-place

  • Click on the data type icon in the column header to change the type

Editing cells

Use arrows to navigate between cells.

Fill with values depending on column type:

String -> fill cells with free text; no quotes are needed.

Decimal -> use a period (.) as a decimal part separator

Boolean -> use values true or false

DateTime -> use format yyyy-MM-dd HH:mm:ss (ex. 2023-04-25 13:54:21)

Date -> use format yyyy-MM-dd (ex. 2023-04-25)

Time -> use format HH:mm:ss (ex. 13:54:21)

You can copy an existing table from Excel or CSV (using hotkeys Ctr+C or Cmd+C, depending on your operating system) and paste it directly into the table in the app by putting the focus in the first field and pressing Ctrl+V or Cmd+V.

Ask AI

Set a prompt, and AI will automatically generate the table. The AI creativity slider sets the "freedom" for AI to generate the result, whether it should strictly match the query or allow deviations.

To get the result from AI, click on the airplane icon first, and if you are happy with the answer, hit "Create table". Hit the "Start new chat" button to start a new chat and forget the previous context.