Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers

Beergod

Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits.

Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted from the target sheet and replaced with the same row except the account ID has been replaced with one without leading zeros.

When using DataMesh to perform the same import function, the leading zeros are preserved between sheets.

Update needed: Allow Data Shuttle to recognize text based numbers that have specific formatting structure in the Excel sheet being uploaded. Additionally it may require allowing Sheet columns to enforce text over number formats rather than being a dynamic mixed use column type.

Danielle Wilson

@Beergod For the mapping step have you set that column as "Text" instead of "Number"? It should honor the leading zeros if you do it that way.