Table Row View

The Table Row view is a view that displays the individual rows of a table and materialized operations in a spreadsheet format. It allows users to see the actual data in their tables and can help them understand the structure of their data and how it is being transformed.

alt text The Table Row view, taken from lambert_2 in the Crime & Heat tutorial.

It preserves the row order between values in columns. It only displays columns that are selected from the Schema View, in the schema-order. This allows you to focus on relationships between values in different columns without being distrated by other columns. Data is paginated in when the user scrolls to the bottom of the view, allowing for efficient rendering of large tables. It displays rows of selected columns in focused tables and materialized operations. Rows can be sorted by clicking on column headers, and the sort order is indicated by an arrow icon next to the column name.

Note: The Table Row view does not currently support multi-column sorting.

Focused operations

The Table Row view will adorn each row with a different icon depending on the type of operation in focus in the Schema View.

Stack operations

When a materialized stack operation is in focus, each row will be adorned with a numbered icon indicated its parent table's position in the stack.

alt text Rows of a stack operation in the Table Row view, taken from the Babyname Politics tutorial. The numbered icons indicate the parent table of each row in the stack operation.

Pack operations

When a Pack operation is in focus, each row will be adorned with the appropriate venn-diagram icon depending on how the two values for the corresponding match columns compare to each other, e.g. match, left-side unmatched, and right-side unmatched. This allows users to easily understand how their tables are being combined together in a Pack operation and identify any potential issues with their match columns.

alt text

No-data States

There are four state where the Table Row View will not display data: unselected, unmaterialized, out of sync, and error. While the first state applies to all data objects, the last three states only apply to operations. The Table Row View will display different messages and visuals for each state to help users understand why their data is not being displayed and how to resolve the issue. These states are designed to provide clear feedback to users and guide them towards taking the necessary actions to view their data in the Table Row View.

Unselected state

When no columns are selected in the Schema View, the Table Row view will display a message prompting users to select columns to view their data. This state indicates that the Table Row view is waiting for user input to display the data.

alt text

Operation-only states

The following no-data states only apply to operations, since source tables will always have data to display in the Table Row view as long as they are selected in the Schema View.

Unmaterialized state

If the operation is not materialized, the Table Row view will display a message prompting users to materialize the operation to view their data.

alt text

Out of sync state

If the operation has been materialized but the schema has since been modified, the Table Row view will display a message prompting users to re-materialize the operation to view their data.

alt text

Note: if the schema is re-transformed into the same state it was previously upon materialization, the Table Row View will remain in the out-of-sync state. This bug will be addressed in the future.

Error state

If there are critical schema errors that prevent materialization, the Table Row view will display a message prompting users to check the error details in the Operation Detail view.

alt text