Uploading data with Data Shuttle, with spaces between numbers.
Mitch Cohen
✭✭✭✭
When I upload a numerical string, which has a space before the last 2 digits, the space is removed. How do I upload the numerical string and maintain the space before the last 2 digits? Example, I need the string to import as "123 45", but after the import it appears as "12345".
Best Answer
-
In your data shuttle workflow mapping, click the three bars and change the column type to Text
Answers
-
Try adding an 'Expression', the last step before you name the workflow. This would be a formula you write to add the space back in.
-
In your data shuttle workflow mapping, click the three bars and change the column type to Text
-
@Paul H Changing the column type to "Text" was the solution.....thanks Paul !!!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 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