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