Data Shuttle Expressions

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!

Find more posts tagged with

Data Shuttle

Accepted answers

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.

All comments

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. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.