Data Set
Using the Data Set step in the builder to enrich raw data inputs with additional data
Last updated
Using the Data Set step in the builder to enrich raw data inputs with additional data
Last updated
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.
Once you've added the 'Data Set' step and named it, like you will with any other step in the Build tool (more on that here), you'll need to add the data set you want to query.
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.
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.
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.
Once you're happy with your data set, just press the 'Save' button in the top right of the screen.
