Skip to Content
avatar image
Former Member

Data records are skipped/missing when loading from Excel to Webi

I am loading an Excel file into Webi. When validating the sum of the Excel data in Webi, I realized it does not tie. I found that the missing data from Excel happened to be on rows 2001, 3001, 4001, 5001, etc. I checked the data rows count in the Webi query and it happens to be the same number of rows as the Excel file so it is odd that the summation is missing the data from those rows. Any ideas on what I am doing incorrectly?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 06, 2016 at 03:33 PM

    check Avoid duplicate row aggregation in format table -- if duplicate data exists.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 28, 2017 at 10:57 AM

    Try changing from .xlsx to .xls

    Add comment
    10|10000 characters needed characters exceeded