Swallow
  • YOUR FIRST MODEL
    • Setting up your first project
    • Manual setup of a new product
    • Excel Model Upload
    • Create your team
    • Essential concepts
      • Syntax
      • Steps
      • Collections
      • Try Model
      • Spotlight
  • PROCESS
    • Team Management
    • Governance & Collaboration
  • BUILD
    • Building with AI
    • Step builder
      • Understanding step types
      • Ordering step blocks
      • Placeholder mode
      • Up/Downloading models
      • Sharing your model
      • Running tests
    • Inputs
    • Enriching Raw Data
      • Transform Data
      • Enrich via API
      • Data Set
      • Collection
      • Custom Code
    • Setting Up Decisions
      • Exclusions
      • Excesses
      • Endorsements
      • Refer
    • Making Calculations
      • Factors
      • Calculation
    • Outputs
  • TEST
    • Creating New Tests
    • Running Tests
    • Editing Tests
    • Reading & Interpreting Tests
    • Impact Testing
  • DATA
    • Working with real-time data
    • Data Views
    • Data Quotas
    • Troubleshooting
    • API Webhooks
    • Data Downloads
  • ADMIN & SETTINGS
    • Project Management
    • Account Management
  • INTEGRATIONS
    • Introduction
    • Payments
      • Stripe
      • GoCardless
      • Adyen
    • Alerting
      • Slack
      • Zapier
    • Data
      • AWS S3
      • Google Sheets
    • Admin
      • Socotra
      • Guidewire
      • Hubspot
      • Salesforce
  • Developer API
    • Introduction
    • Authentication
    • Errors codes
    • Endpoints
      • /quotes
      • /projects
      • /tests
      • /process
Powered by GitBook
On this page
  • 1. Select the input you want to enrich
  • 2. Upload your table
  • 3. Check the uploaded data set
  • 4. Save the step
  1. BUILD
  2. Enriching Raw Data

Data Set

Using the Data Set step in the builder to enrich raw data inputs with additional data

PreviousEnrich via APINextCollection

Last updated 1 year ago

Once you have inputs set up, you can start using those inputs as keys to add additional data. By using this step, you can map data against the key.

If you'd prefer to query a whole database and selectively store data from only a few columns, you can use the Collection step instead.

How might you use the 'Data Set' step?

If you were building a pricing model for insurance, the address where the property is located would play a vital part in your pricing decisions.

By uploading a table of risk ratings for a number of different factors, you could use the 'Data Set' step to add all of the columns in your table to the quote, based on the postcodes entered by a customer.

1. Select the input you want to enrich

To get started, click the cog symbol in the top right of the 'Data Set' step.

Click on the drop-down menu to select the existing input you want to enrich from the data set you're uploading. This will set the key that your data set table will be mapped against.

2. Upload your table

You can then copy a data table and paste it directly into Swallow, or you can drag-and-drop a CSV document, which will upload immediately.

The first column's name must match the name of the input you've selected in step 1. If it doesn't, you'll receive a warning message to update it before it will upload successfully.

3. Check the uploaded data set

Check your table has uploaded correctly. If you want to replace, bulk edit or delete the data, you can do so by using the 'Download', 'Upload' and 'Delete' buttons above the table.

4. Save the step

Once you're happy with your data set, just press the 'Save' button in the top right of the screen.

Once you've added the 'Data Set' step and named it, like you will with any other step in the Build tool (), you'll need to add the data set you want to query.

more on that here
The Data Set step
Selecting the input you want to map to your data set
Uploading your data set dialogue box
Save step button