I need Data Shuttle to work with Trailing Zeroes
This is a huge pain point for me.
I often have Data Shuttle lookup values that end in a zero (like 6457813.54610). When I set up a data shuttle, the rows that have a trailing zero don't pull back match when the Data Shuttle runs. I REALLY don't want to have to write a function that says: look for the "." and if the count of the numbers after the "." is = 4 then take that number and add a "0" to the end. Such a pain!
Best Answer
-
For the 0 being dropped problem, you can edit the mapping in shuttle and set the column to import as text instead of auto. Auto will turn anything that looks like a number into a number. Give it a try?
Answers
-
For the 0 being dropped problem, you can edit the mapping in shuttle and set the column to import as text instead of auto. Auto will turn anything that looks like a number into a number. Give it a try?
-
@Tim C, if this works, you just saved me LOADS of time!
I'll check it out :)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Posts
- I've set up a archiving workflow using an archive checkbox column in our intake sheet through our blueprint. When this criteria is met, the project is supposed to be moved into an archive workspace, t…
Anyone has a problem Datamesh error code 1302;You cannot edit cells with Column Formula for column(0
Dear Support, I created a Datamesh with lookup value from a Formula column (source column), once run the config, then show error "code: 1302; message: You cannot edit cells with Column Formula for col…- Hi all, I was just informed by our I.T. Dept that Microsoft is killing the Outlook Add-in. We use this add-in quite extensively. Is anyone out there aware of a quick and easy way to attach emails to s…
