Import Microsoft Excel vs Data Shuttle - Not Consistent

marc4

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

Brian_Richardson

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.