How to filter text out in Data Shuttle
Hi everyone!
I am trying to filter out text in cells when I pull the information from Data Shuttle, but nothing else in the column gets updated. How should I do this correctly? Here's the Google sheet I'm pulling the info from:
I made the value under "Biomarker Assessments" = $2,492 so I can see if a change occurs in my target Smartsheet:
And I want Data Shuttle to not upload the words "Total Amount", so I have this:
But when I run the workflow, it does not update the target Smartsheet with anything, it keeps the original value under "Biomarker Assessments" at $2,490 instead of updating to $2,492.
I know I must be configuring this incorrectly, but the different ways I have tried to fix it have not been successful. I appreciate the help in advance!
Answers
-
I think you want Biomarker assessments to "Not Equal" Total amount? I believe you also need unique identifiers for Data shuttle to work. Do you have those in a column somewhere?
-
Hi Samuel,
I tried doing the "Not Equal" before and got the same result. I just tried again and still no dice.
I do have unique identifiers: it's my Store column.
The workflow in Data Shuttle works great as far as updating the revenue each day, I'm just unable to remove this text.
-
Do you have the workflow set up to replace all values or update values? If it's not replace all values then it wouldn't remove anything.
-
Gotcha, is there a way that it can just remove the text I put in? Is that possible at all with filters in Data Shuttle?
-
So the filter you have if you make it "not equals to" it should ignore the text and not bring it in. you may have to delete it from your Smartsheet initially though. With the filter it shouldn't put it back when the data shuttle runs if you have the right filter..
-
-
Hi @Paul H ,
I think the issue there is in my Google Sheet, the second row has the same header, so it makes it more difficult for mapping:
Unfortunately I'm not able to change that. This information is actually coming from Google's reporting tool Looker. It sends out a Google sheet on a frequency I set, and in order to pivot the categories out and see how much each category makes in revenue, this is how it's sent out from Looker into the Google sheet. So for Data Shuttle, I have to keep the first row option as 1 so I can properly map the headers to the Smartsheet columns.
Does that make sense?
-
I changed the filter to "not equals to" and it still brought in the text. I made sure to delete the text prior to running the workflow in Data Shuttle. I am definitely at a loss here.
-
Take out the quotes and just use Total Amount
-
That did it. Thank you so, so, so much!
-
No problem! It's always the little things lol
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives