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.
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!
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.
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!
-
Thanks for the response! I figured it was worth asking, I'll do one of those.
-
Happy to help. 👍️
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives