SOLVED
Maintain String format in a CSV File --
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ll98
9 - Comet
‎07-17-2021
02:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have an issue where the DATA displays correctly in Desginer output -- however, when it outputs to a csv format the data changes .. Hence, designer shows it as 0100 -- however, when it output to CSV format, it changes to 100. Are you able to assist
Account |
100 |
Solved! Go to Solution.
Labels:
- Labels:
- Optimization
- Output
6 REPLIES 6
20 - Arcturus
‎07-17-2021
05:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎07-18-2021
05:33 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew -In Notepad it shows as 0100 -- Which is how I want to show it in the CSV.file
‎07-18-2021
05:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew I'm loading the file into a database and it needs to be loaded as '0100" instead of 100....
20 - Arcturus
‎07-18-2021
05:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As long as the db has it defined as a string, you should be good.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
‎07-18-2021
05:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew Thanks
20 - Arcturus
‎07-18-2021
06:16 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
