Skip to content

Rows are silently skipped if they contain non-numeric data for an integer measure #53

@sduncan01

Description

@sduncan01

If a row in a source file contains non-numeric data for a field that is being used as an integer measure, that row is not included in the generated source table (and therefore isn't included in the cube either). The Import Data dialog gives no indication that any errors occurred.

The following source data from https://www.baseball-reference.com/teams/BOS/ reproduces this issue when the "GB" (games back) column is included as an integer measure - 19 rows are skipped because they contain "--" to represent 0 in that field:
redsox_seasons.csv

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions