Guided source import
Inspect and edit the source data
Source table: shifts in the linked operating model.
- employee_id
- employee_id
- date
- date
- paid_hours
- paid_hours
- hourly_rate
- hourly_rate
- base_pay
- base_pay
- Open the linked operating model in the text and data editor. Find tables.shifts.rows to inspect the records and exact field names.
- Keep identifiers as quoted text, retain the other tables and compare edits with the linked schema and expected results. Save a local copy before changing records.