Now that you have added your source data into your project, Aragorn provides an intuitive interface where you can inspect, select, view, and filter data to ensure it was correctly loaded and added before using it in an integration. This allows you to verify that the necessary records and fields are available, identify any missing or incorrect data, and refine the dataset as needed.
Including and Excluding Columns from your view
By default, Aragorn displays only a subset of columns from your source data. During the time you are inspecting your data, you can choose to select more columns that you want to display.
Locate the “Project Columns” section at the right of the table.
Click on any field in the list of columns to bring into the table
Toggle the eye icon to open or close to show or hide specific columns in the data table on the left
For example, If you're only interested in c_job_title and c_is_supervisor, you can click on those two closed eye icon to reveal the data for those fields in the table while keeping the others hidden.
Filtering data with test filters
If you want to inspect specific subsets of data, you can use the Search Filters feature.
Click the Search Filters button.
A filter panel will open where you can set conditions based on column values.
Click the Add filter button.
Select a field to filter by (e.g.,
is_terminatedto find active or terminated employees).You can also use the search box at the top to easily find and select the filed you want.
When inspecting your source data, you can refine your dataset by applying filters to display only the records that match specific conditions. This helps you focus on relevant data, identify missing values, and ensure accuracy before integration.
Choosing a filter condition
You can apply filters using different conditions to customize your data view. Available conditions include:
= (is) - Example:
is_terminated = trueto show only terminated employees.≠ (is not) - Example:
is_terminated ≠ trueto show only active employees.> (greater than) - Example:
salary > 50000to show employees earning more than 50,000.>= (greater than or equal to) - Example:
salary >= 50000to include employees earning 50,000 or more.< (less than) - Example:
salary < 50000to show employees earning less than 50,000.<= (less than or equal to) - Example:
salary <= 50000to include employees earning 50,000 or less.<Empty> (is empty) - Show only records where a specific field has no value.
≠ <Empty> (is not empty) - Show only records where a specific field contains a value.
Click the Test filters button to test your filters.
Adding Multiple Filters
You can combine multiple filters using the AND operator to refine your data further. For example:
is_terminated = falseANDsalary > 60000. This filter will display only active employees with a salary greater than 60,000.
Click "Add Another" to keep adding filters as needed.
Download data (must have permission & for employee data projects ONLY)
Permitted account users can use the download button to save the data to your computer.