-
Data Shuttle and Googles Sheets that are connected by BigQuery
Hello all I wanted to use Data Shuttle to import data from Google sheets. This sheet has multiple tabs of which some are connected by BigQuery and some are not. When I use Data Shuttle and target the "connected" tabs the mapping only shows the name of the Tab itself and not the column names. But if I select a tab that is…
-
Data Shuttle expressions
Hello How can I get the total count for all entries on a weekly basis using Data Shuttle? Currently I get the total count imported to a sheet. This count is currently 26 entries and it fluctuates weekly. I would like a way that data shuttle using expressions can provide me this total count in one cell. Thanks for your help.
-
How can I upload Excel without losing groups and hierarchies?
My excel has rows that are indented to show groups and hierarchies. Can Data Shuttle do the upload so that I don't have to manually recreate ancestor levels?
-
Data Shuttle 'contains' filter does not return any results
I am trying to filter a column that has a list of document names. Some of the documents are 'plans' Example: Onsite First Installation Plan - v08 I want the filter to only return rows where the document name in the row has the word 'plan' in it. When I try the contains filter, Data Shuttle filters out all the rows and…
-
Data Shuttle support
Hello I currently have one main sheet used as a central repository. I have another sheet in which I have manually populated data from the main sheet. I would like to use Data Shuttle to automatically populate that data every week. Thanks
-
Best Way to Pull A Ton of Data
Hello Community, I have recently been given the challenge of pulling a ton of data from a source sheet to a target sheet, and am trying to figure out the best way to pull all the data efficiently and not run out of space too quick. Unfortunately we cannot use data mesh because each row has 7 target columns to pull from.…
-
Archive Data Shuttle Workflows
Hi Community, Users can now archive Data Shuttle workflows that will be paused and remain in the archive for 90 days before being permanently deleted. Archived workflows will be moved to the Archive Dashboard in Data Shuttle and users will have 90 days to restore workflows if needed before they are permanently deleted. Any…
-
Data Shuttle Workflow Activity Log
Hi Community, With this release, we have introduced an activity log that allows Data Shuttle users to see details about workflow changes. The activity log will help users track actions taken on a workflow over time, creating an audit trail of its history to help troubleshoot errors. You can learn more about the Data…
-
Data Shuttle - Need to filter new hires within last 30 days
Hi everyone, I'm trying to set up a Data Shuttle offload that will export the following information into OneDrive: Employee Name Role Manager Employee Type Hire Date The problem I'm running into is that I am not seeing any viable way to filter the results within the last 30 days. I setup a report for this as well but…
-
Need a solution to move some unique IDs from one sheet to another
Hello! I have a main intake sheet for my team to manage studies. Every time a new row is added, a unique identifier (for each unique study on this main intake sheet) is created. We have at least 3 different services that are listed on the main intake sheet. Each service a study team is requesting is marked with a checkmark…