Announcement

Collapse
No announcement yet.

Ignore missing cell in csv compare

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Ignore missing cell in csv compare

    When comparing CSVs there's already functionality to specify a tolerance with numeric fields. Both absolute and relative percentage. However, if a cell is missing completely then it shows up as a difference even though the value comparing against is within the tolerance. For example how can I specify any changes within a tolerance of 10, counting null/missing as within tolerance.

  • #2
    Hello,

    As an empty cell, BC4 does not currently attribute a default status that could be tolerated. Would, in this case, the assumption be "0" for an empty numeric cell? This gets a little trickier for a Boolean column (should it be "0" = False, too?) or an empty Date. This is something we can investigate adding as an option, but the current behavior will consider a missing cell as without value, so it wouldn't fall within a tolerance between two values.

    The entire column could be marked as Unimportant by right clicking the column header and setting the existing column that is aligning to no information as Unimportant.
    Aaron P Scooter Software

    Comment


    • #3
      I appreciate it'll be tricky for non numeric columns. However, for types that can be used to compute a relative or absolute tolerance (I have only used these with numbers) perhaps there could be an option on how to deal with empty cells. Whether to assume 0 (which would be my preference) or another value.

      Comment


      • #4
        Hello,

        Thanks for confirming. I've added this idea to our Customer Wishlist, where our developers go for ideas for future features and enhancements. It's not a feature we'll be able to implement short-term, but something we can look into.
        Aaron P Scooter Software

        Comment

        Working...
        X