Table

Understanding columns

Columns define the structure of your table and how data behaves. Each column has a name, a semantic data type, and a column type that controls whether it stores data, fetches it, computes it, or transforms it.


The six column types

Static columns (yellow)

Basic data storage. You enter or import data directly, like a regular spreadsheet cell.

Use for names, domains, emails, or any data you already have.

Processor columns (blue)

These run enrichment actions through connected integrations or providers. When you run enrichment, processor columns connect to external data sources to find information.

Use for finding work emails, job titles, company information, or anything you need to look up.

Data source columns (pink)

Pull data from an external connected source, like a CRM or database sync.

Use for keeping table data in sync with external systems.

Derived columns (green)

Compute values using formulas based on other columns in the same row.

Use for combining first and last name, calculating scores, conditional logic (IF/THEN), or extracting parts of data.

Waterfall columns (light blue)

Try multiple providers in sequence until data is found. If the first provider doesn't return a result, the next one tries automatically.

Use for maximizing data coverage on fields like email or phone number.

Output columns (purple)

Hold data received from webhooks. When external systems send data to TexAu via a webhook, it lands in these columns.

Use for receiving data from external systems in real time.


Column color coding

Each column type has a distinct color in the table header, so you can see your table structure at a glance:

This table scrolls sideways on small screens.

TypeColor
StaticYellow
ProcessorBlue
Data SourcePink
DerivedGreen
WaterfallLight Blue
OutputPurple

Adding a column

  1. Click the + icon at the end of your column headers.
  2. Choose the column type (Static, Processor, Data Source, Derived, Waterfall, or Output).
  3. Name your column clearly (for example, "Work Email" or "Company Size").
  4. Select the semantic data type (Email, Phone, Company Name, etc.).
  5. Configure type-specific settings:
  • Processor: choose the data provider and map input columns.
  • Derived: enter your formula.
  • Waterfall: select providers and set the priority order.
  1. Click Save.

Managing columns

Renaming

Click the column header, select Edit, and change the name.

Hiding and showing

You can hide columns you don't need visible without deleting them. Hidden columns keep their data. Use the Show Hidden Columns button in the toolbar to bring them back.

Deleting

Click the column header, select Delete, and confirm. Deleting a column removes all its data permanently.

Tip: If you're not sure whether you need a column, hide it instead of deleting it.


Column limits

All plans support up to 100 columns per table. Most tables use 15-30. If you're approaching the limit, consider splitting into multiple tables with a shared identifier like email or company domain.


Next steps