Add lookups from data sources
This page provides a guide on how to add lookups from data sources in Upsolver.
Last updated
Was this helpful?
This page provides a guide on how to add lookups from data sources in Upsolver.
Last updated
Was this helpful?
1. Click Add Lookup or in the Calculated Fields tab, under Lookups, click.
2. In the Data Source tab, select a source for your lookup.
3. Click Next.
4. Under Join Fields, select the fields to use as key columns.
5. Select at least one aggregation and the field to apply it to. See: Aggregation functions
6. Select the desired time frame; this enables you to sync your data sources.
You can also set the time frame to infinite by checking Infinite From. This ensures you can access all the data irrespective of when it was written.
7. Check Use Full History to use all the data that was available when deploying this output for historical lookups.
8. Decide whether or not to implement an inner join.
9. 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.
10. Click Preview to review your calculated field before saving; a Field Content Samples panel will appear on the right.
11. To add columns to the preview, click Choose Columns and select the desired columns. Then click Update.
12. Click Save.
You can now find this lookup under Lookups in the sidebar or under the Calculated Fields tab.