Resolving Row Count Discrepancies After Uploading Excel Files in Bold BI^®

When uploading Excel files to Bold BI^®, users may encounter discrepancies in row counts. This issue often arises due to formatting errors within the Excel document.

Common Cause

One common cause of row count discrepancies is improper formatting of text within the Excel file. For instance, if a text entry begins with a quotation mark but lacks a corresponding ending quotation mark, the system may interpret the entire row as a single cell. This can lead to an incorrect count of rows when the file is processed.

Example Scenario

In a specific case, an Excel document contained a line where the text “DECAN GARDENIA 2” started with a quotation mark but did not have an ending quotation mark. This formatting error caused the remaining content in that row to be treated as part of a single cell, resulting in an inaccurate row count.

Recommended Solution

To resolve this issue, it is essential to ensure that all text entries in the Excel file are correctly formatted. Specifically, if a text entry begins with a quotation mark, it must also end with one. Please follow the below suggested steps to overcome this issue:

Steps to Fix

1. Open the Excel file.
2. Navigate to the line with the formatting issue.
3. Add the missing ending quotation mark to the text.
4. Save the document and re-upload it to Bold BI^®.

Once the necessary corrections are made, the row count should align with the expected number of rows in the excel file.

Conclusion

Proper formatting of Excel files is crucial for accurate data processing in Bold BI^®. By ensuring that all text entries are correctly formatted, users can avoid discrepancies in row counts and ensure smooth data uploads.

For further assistance or inquiries, please reach out to the support team.

Additional References

• Excel Data Connection