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!
Best 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.
Answers
-
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.
-
Thanks for the response! I figured it was worth asking, I'll do one of those.
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives