SOLVED
Convert Embedded Lines into Single Lines and eliminate truncated characters
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
OmaratRJL
7 - Meteor
05-07-2018
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a web based csv file that contains two essential fields somewhere in the second field there is an embedded carriage return(enter) and hidden characters. If I physically download the file there are no issues but if i open it up through Alteryx there is an error. So what exactly is happening here and what can I do to resolve it?
Solved! Go to Solution.
Labels:
- Labels:
- Connectors
- Download
- Preparation
1 REPLY 1
LordNeilLord
15 - Aurora
05-07-2018
08:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @OmaratRJL
You can use the download tool to place the csv in a tmp file and then use the dynamic input tool to open the CSV...this will solve the issue you are having.
