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

[Akash01]

Hey, 

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

[JordanB]

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

[Akash01]

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

[JordanB · Accepted solution]

Updated workflow avoids hardcoding field headers by transposing the data

[Akash01 · Accepted solution]

Thank you so much @JordanB!

You were a great help. :)