Import Microsoft Excel vs Data Shuttle - Not Consistent
I'm running into an issue between how Import Microsoft Excel works vs Data Shuttle. I have a csv file from GA that looks like this
Nth week | Average engagement time per active user |
---|---|
0000 | 112.22953736654804 |
0001 | 70.001269035533 |
0002 | 64.25891677675033 |
It gets imported with the first column losing the leading zeros. Then there are calculations later in the sheet based on the cells.
I want to update this sheet every day with the new values for Average engagement time per active user and not lose my calculations so I am using Update Rows rather than replace the entire sheet.
The update doesn't work. If I change the Data Shuttle to "Add rows to the sheet" then Data shuttle adds new rows with the leading zeros. Once I add the leading zeros back to the sheet, the Update… works.
The behavior of these two should be consistent.
/marc
Answers
-
The update isn't working because it's not matching the value in Nth week of 0001 with the imported value of 1.
Weird that doing a regular import (I assume you mean… click Create…Import) drops the 0s… it's obviously not seeing that column as text but rather as numbers and picking up the value only. Can you add something to Excel, maybe another column, that wraps those numbers in quotes or appends a letter that you can then formulaically strip back out once imported.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives