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!

Step1_HyperLink (API) with employee ID added.png

Step2_Download tool config.png

Step3_Output showing truncation.png

Step4_Formula showing dots after 255 characters.png

Workflow.png

API

Download

Accepted answers

kempo1981

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

Solution.png

All comments

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335