Can I use DataShuttle to consolidate data?

I have many files that are formatted the same, but contain different data. I would like to use DataShuttle to consolidate the data into a single Smartsheet spreadsheet via an Upload Workflow. I simply want the data from each uploaded file to be added to the target sheet. Is this possible?

Here is the process that I am currently using.. it is not ideal..

Target -> Workflow Action: Merge data into the target based on a key column value

Target -> Row options: Add rows to the sheet as they are added to the source file

This method enables me to populate the target sheet with data from each file upload. However, it forces me to include a Row ID in each individual data file. I would like to avoid having to include a Row ID or any other unique identifier in my data files if possible.

Any suggestions?

Find more posts tagged with

Automations

Accepted answers

All comments

Ryan Sides

@AntonioRayo

Hi Antonio, Yes! It's a perfect use case for it. Just make sure your spreadsheets have the same column headers to make it easy on yourself.

AntonioRayo

https://community.smartsheet.com/discussion/comment/347112#Comment_347112

Thanks for your reply, Ryan.

Could you please share information on how to setup a workflow to simply add data to a sheet when a file is uploaded in the same format?

Here is the process that I am currently using.. it is not ideal..

Target -> Workflow Action: Merge data into the target based on a key column value

Target -> Row options: Add rows to the sheet as they are added to the source file

Any suggestions?

Ryan Sides

I set mine to upload on attachment. So just upload your excel sheet (I'm guessing?) as an attachment to the first row in your sheet. Then build your Data Shuttle steps (using the screenshots below). Then delete your attachment on the first row and reattach it (that will start the Data Shuttle process). Then attach your next spreadsheet, and your next, etc.

Try those settings.

Please let me know if it works for you.

Ryan

Ryan Sides

@AntonioRayo Hi Antonio, just following up. Did that work for you?

Michelle Fayed

@Ryan Sides I'm a little late to the party and hoping to follow up on this post with a question, please. Will data shuttle automatically add any new rows under the last entry with the same key column value, or just add it to the bottom on the sheet? Meaning with it sort it when merging the data?

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.