Tablora · Library
Keep a header whose case changed
A repeated header in capitals, like NAME and AMOUNT, is not an exact match for Name and Amount, so the cleaner keeps it. Here is how to review it.
Why NAME is not the same as Name here
Repeated header cleanup removes a later row only when every cell equals the chosen header row. Before comparing, it trims spaces at the start and end of each cell, but it does not change letter case. So when the header is Name and Amount, a later row reading NAME and AMOUNT is treated as a different row and stays in the output.
This is deliberate. Some exports switch to capitals on later pages, but a row in capitals can also be a section title or a real record. The tool leaves that decision with you instead of guessing.
The same strictness applies to spelling and punctuation. Amount: with a colon, Amounts with an s, or a header that gained a currency code on later pages all count as different rows. Removed header rows is the quickest way to see whether your expectation and the source agree: if you expected one removal per page break and see fewer, look for rows like this one.
Example: one header kept in capitals
In the page example the Header row is 1, and the table has three source rows: Name and Amount, Paper and 12.50, and NAME and AMOUNT. After Calculate, Removed header rows shows 0, no source row is removed, and the output still has 3 rows. The third row is kept exactly as it was, capitals included.
Deciding what to do with the capitalized row
- Look at the source page where NAME and AMOUNT appears. If it sits at the top of a new page or section, it is almost certainly a repeated header.
- If you confirm that, change its letters in your copy of the text to match the chosen header exactly, then press Calculate again. Removed header rows should now show 1.
- If the row is a section label or holds real data, leave it in and handle it in your spreadsheet.
- Never retype the chosen header in capitals to force a match; the first row is what the output keeps as its header.
How the app compares headers when merging pages
In the Tablora app, Merge pages joins tables that have the same number of columns as the first table. When Header row is on, it drops the first row of a later table if it matches the first table's header, and that comparison ignores letter case as well as outer spaces. So a NAME and AMOUNT row at the top of page two would be removed during a merge, while the browser cleaner keeps it.
Neither behaviour is wrong; they answer different questions. If you work in both places, check the merged result against the source before you export it.
Original synthetic example
- Browser header row
- 1
- Removed source rows
- None
- Output rows
- 3
| Source row | First cell | Second cell |
|---|---|---|
| 1 | Name | Amount |
| 2 | Paper | 12.50 |
| 3 | NAME | AMOUNT |