Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Create Error Message when fields have been truncated

PeterAP
8 - Asteroid

Is there a way I can produce an error message in an app when fields have been truncated?

2 REPLIES 2
OllieClarke
15 - Aurora
15 - Aurora

Hi @PeterAP, this might be possible, but it depends on the specific use case you have/what you're trying to do/where fields are bing truncated. Could you provide a bit more detail please?

danilang
19 - Altair
19 - Altair

Hi @PeterAP 

 

Can you provide specific details about how the fields might be truncated?  There are a couple of ways that I can think of such as changing the field length with a select tool, or adding to text to a field in a formula tool.  Both of these also give warnings as opposed to errors, so you need to planned for and handled with good error management in your workflow.     You can of course set the workflow to stop after any conversion error in the Runtime settings.  But this is messy. and doesn't give the user any valuable info

Error on conversion.png

A better option is to plan for these types of errors.  Use a combination of the Field Info tools and a series of message tools to check field lengths and types on input.  When adding text to a column ensure that the field length is set to a large enough value at the start of the workflow.  

 

Dan

Labels