Filters in Datashuttle Using Checkbox (True/False)
Some of you may already know this but for several days (weeks if I'm honest), I've been struggling with why the filter in a DataShuttle was not excluding the rows that data issues (i.e. were not checked and cleared to move to the next step). I have the column set up as checkbox and use a formula to check several other columns for completeness, accuracy and number of characters in taxonomy. The trick is that even though in the exported CSV file the column shows the values as TRUE and FALSE, the filters in DataShuttle are case sensitive and require that all be lower case: true and false. I hope this saves you some time if you have a similar situation.
Comments
-
Hey @Amber Grossman
Thank you for posting your solution!
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!