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

  • Brian_Richardson
    Brian_Richardson Overachievers Alumni

    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.

    BRIAN RICHARDSON | PMO TOOLS AND RESOURCES | HE|HIM

    SEATTLE WA, USA

    IRON MOUNTAIN