Data Shuttle Expressions

kira11

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!

Paul Newcome

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.

Paul Newcome

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.

kira11

Thanks for the response! I figured it was worth asking, I'll do one of those.

Paul Newcome

Happy to help. 👍️