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.
SOLVED

Any way to report on the WIDTH of a text document?

bdpowell
7 - Meteor

Good Morning!

 

I have a need to report on the width of a text file. The width for this extract must be the same every time and we would like to have a validation.

 

I know I can easily get the length by adding a record count and counting those, but I need to be able to pull the total width of my text files.

 

Does anyone know a way to do this?

 

Thank you!

 

Ben

3 REPLIES 3
SamDesk
11 - Bolide

Hello @bdpowell,

 

If by Width you are referring to how many characters are contained in a field then this would be called the field length and we can calculate this using a formula tool. I've created a dummy workflow to show this.

 

Capture.PNG

 

Sam :)

bdpowell
7 - Meteor

That got me on the right track!

 

I ended up using another action tool to update a copy of the text file and made that 1 field. Then I just did the length formula and it worked.

 

Thank you,

 

Ben

SamDesk
11 - Bolide

Glad it got you sorted!

 

Sam :)

Labels