download tool causing truncation
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I am using the download tool to connect to our HR system and return details of the 'chain of command', however it seems the field that is returned is truncated meaning I am unable to return any data after 255 characters. I set the field as VW_STRING, but am not sure what else I need to do?
Any advice would be greatly appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @kempo1981
The data is probably not really truncated. It's just that Alteryx doesn't show all your data if you don't place a browse tool. This is to improve performance.
Try placing a browse tool and viewing the data in it. Does this resolve the issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Kat,
Thank you for your reply, I will try that.
My concern though is the browse tool will allow me to view the full data, but I want to extract information from it and I cannot due to the truncation.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I added a 'text to columns' which seems to have worked :)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your data is always there - it's just truncated in the view. So any tools that you place, like the text to columns, will work on all the data.