I need Data Shuttle to work with Trailing Zeroes

Kayla Q

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!

Tim C

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?

Screen Shot 2023-03-01 at 9.05.08 AM.png

Uploaded Oct 19, 202327.96 KB

Tim C

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?

Screen Shot 2023-03-01 at 9.05.08 AM.png

Uploaded Oct 19, 202327.96 KB

Kayla Q

@Tim C, if this works, you just saved me LOADS of time!

I'll check it out :)