Skip to Content
0

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

Dec 04, 2016 at 11:50 PM

131

avatar image

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?

10 |10000 characters needed characters left characters exceeded

can you please share the screenshot of row 2001 where data is present in excel and not in webi?

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Venkatesh Katta Dec 06, 2016 at 03:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Kellie Cenzano May 28, 2017 at 10:57 AM
0

Try changing from .xlsx to .xls

Share
10 |10000 characters needed characters left characters exceeded