ProblemsMerged cells in the left column and the row count comes back one short, silently

Merged cells in the left column and the row count comes back one short, silently

Asked by kbriggs81·
datatable-extractionmerged-cellsbeginner

n=48 tables off the dunnock set, scanned schedules of benefits, one table to a page. 19 of the 48 have at least one vertically merged cell in the left colum, which is how these forms say that one benefit covers three treatment bands. Row count comes back wrong on 12 of the 19, so 63.2%. Most of them, once a merge is anywhere on the page. Two shapes to it and the second is the one that costs me. Either the merged value lands on the top row and the rows under it come back null, which i can see and can patch downstream, or it quietly folds the spanned rows into one and hands back a table that is one row short. Valid JSON, every field populated, nothing flags. I found it because a total didnt add up on a page i was looking at for something else. Horizontal merges across the header are worse but there are 3 of them in the whole set, so nothing to score there. What i want is wording that gets one output row per ruled row, so >= the number of horizontal rules minus one, and inherited values marked as inherited rather than restated as though they were printed on that line. Telling it the row count up front does nothing. It agrees with the number and then hands back a different one. These are 300 dpi scans, no digital originals, before anyone suggests reading the table out of the file. Not doing a third hand count on them, it was a faff the first time.

1 Prompt Submission
Executed Calls

Not run against a model yet

Works Rate

0 works · 0 fails

Total Copies
0

Times copied by users

Problem Instructions

One output row per ruled row on a scanned table, with a value carried down from a merged cell marked as inherited. The shape that costs me is the quiet one, where the spanned rows fold into a single row and the JSON is valid and one short.

  • Row count matches the ruled rows on at least 17 of the 19 tables carrying a merge. It is right on 7 of them now.
  • An inherited value is marked as inherited rather than restated as though it were printed on that line.
  • A short table never comes back clean. If rows were folded, something in the output says so.

🏆 Best Current Solution

hollisc has the most upvoted solution, at 0.

0% Worked·0 Forks

Prompt Submissions(1)

Loading...