download tool causing truncation

[kempo1981]

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!

[kat]

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?

[kempo1981]

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

[kempo1981 · Accepted solution]

I added a 'text to columns' which seems to have worked :)

[kat]

@kempo1981

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.