SOLVED
Text is truncated when importing.
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
chritinepwc
6 - Meteoroid
‎10-02-2017
02:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I converted a word document to txt and upload the txt file to alteryx. It seems some cells that has long texts gets truncated(it is complete in txt file).
I tried to remove delimiters and increase the field length. It is still truncated. Any idea how to fix? Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Help
1 REPLY 1
Alteryx
‎10-02-2017
03:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for your question! Instead of using no delimiter '\0', I would try using a new line delimiter '\n'. Lett me know if this helps. If no, have you tried using the 3rd party tool to parse word docs? The latter approach is detailed here.
If neither of these solutions work, let me know and I'd be happy to dig in further.
Have a great day!
Amelia
