I should stress that I've already submitted a support ticket about this issue, but I'm curious whether any other users have experienced something similar. (So far, support has been unable to replicate it - confusing all around!)
I have a large (~20,000 record) Google Sheets tab containing records of driver data - how many hours each driver works in a given day. There's one unique record for every combination of driver and date.
When we try to import this data into Google Sheets, we run into a bizarre problem where the first column in the spreadsheet (the date column) gets corrupted. Sometimes a date gets repeated twice; sometimes it gets eliminated entirely. Here's a couple screenshots of the first two columns, first in the original, second in the Sisense import showing the problem. *Only* the first column is affected; the other columns contain the exact data we would expect.
Sisense after import:
As you can see, 11/4 gets repeated, 11/6 disappears, 11/7 gets repeated, and 11/9 disappears.
These problems are scattered seemingly at random throughout the Sisense import; approximately 1 in 20 records is altered.
Does anyone have a clue as to what might be going on here, or has anyone experienced something in the ballpark of this?
I should also stress that Excel and CSV uploads of the exact same data work perfectly.
Please sign in to leave a comment.