Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Troubleshooting
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Data outputs
Data transformation
Transform with SQL
Work with Arrays
View outputs
Create an output
Modify an output in SQL
Add calculated fields
Add filters
Add lookups
Add lookups from data sources
Add lookups from lookup tables
Adding lookups from reference data
Output properties
Run an output
Edit an output
Duplicate an output
Stop an output
Delete an output
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By
GitBook
Adding lookups from reference data
This article provides a guide on how to add lookups to lookup tables (or outputs) from reference data.
1. Click
Add Lookup
or in the
Calculated Fields
tab, under
Lookups
, click
.
2. Under the
Reference Data
tab, select a source for your lookup (or
create a new one
).
3. Click
Next
.
4. Under
Key Fields
, select the fields to use as key columns and map it to a field in your output.
5. (Optional) Select the
value fields
.
6. Under
Refresh Interval Seconds
, input the number of seconds between attempts to refresh the reference data file.
7. Select where to locate the calculated field (e.g.
root
,
data
) and
name
this field. This operation joins the input arrays using a cartesian product.
The fields are typically added at the
root
level, however on occasion you can opt to co‑locate a field with another element in the hierarchy.
8. Click
Preview
to review your calculated field before saving; a
Field Content Samples
panel will appear on the right.
9. To add columns to the preview, click
Choose Columns
and select the desired columns. Then click
Update
.
10. Click
Save
.
You can now find this lookup under
Lookups
in the sidebar or under the
Calculated Fields tab
.
Previous
Add lookups from lookup tables
Next
Output properties
Last modified
1yr ago
Copy link