Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors