community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

I want to filter out the fields having the data length more than 100 and show an error.

Highlighted
Asteroid

Hey, 

I need some help to filter out the fields having length more than 100 and show a error message reporting it.

Alteryx
Alteryx

Hi @Akash01

 

Please find a workflow attached which looks at cells in a field which are greater than 100 characters in length.

 

I have used the message tool to create a dynamic error message based on the row and the number of characters in that field

 

Jordan

Asteroid

Hi @JordanB

 

Thanks for helping me out, but I wanted a standard workflow which would work for every input file having different field names.

It would be time consuming and tiring to put each of the field names in the "formula tool" and checking the length, if a file would be having more fields.

 

Regards,
Akash

Alteryx
Alteryx

Updated workflow avoids hardcoding field headers by transposing the data

 

 

Asteroid

Thank you so much @JordanB!

You were a great help. :)

Labels