Data Shuttle Expressions

kira11
kira11 ✭✭✭
edited 09/09/24 in Add Ons and Integrations

I have an Excel sheet and a grid that I am using Data Shuttle to update. My question is: The two columns I care about are Job # and Hours. I was using Job # as the unique identifier in both the Excel and the grid but it is no longer unique in the Excel file, meaning there are now multiple rows with the same Job # but various Hours. In the grid there is still one row per Job #. Is there a way to sum the hours under each distinct Job # coming in from Excel with the Data Shuttle?

I have never used the expressions functionality so was wondering if that could be of use for this problem? I am open to any thoughts or recommendations. Thanks!

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    There is no way to get Data Shuttle to do this. You would either need to summarize in the Excel file and then import, or you would need to import all rows and then summarize in SS.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers