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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Field Names Too Long - how to count field name characters

Asteroid

Field Names Too Long - how to count field name characters

 

I'm outputing data to a .tde and Tableau has a max field name character count 128 - 

There are hundreds of fields, so I need to find which field names are too long, so I can change them.

 

How can I count the characters in a field NAMEs - not the values in the fields, the field NAMES/TITLES

 

Then can I do a bit of find and replace to fix this?  

Since many of the names are similar I'd like to do a global rename, or something efficient like that.

 

Here is a small sample of the field names I'm dealing with.

long field NAMES.JPG

 

 

Alteryx Certified Partner
Alteryx Certified Partner

@brendafos ,

 

Use a field info tool and then put a formula to calculate the Length() of the field name.  This is NOT the exact formula, just a hint.

 

cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I put together an example of how the Find Replace and Dynamic Rename tools can be used to apply some global name replacements.

I hope this helps!

Asteroid

Thank you.  This is exactly what I needed.  

Alteryx is just wow for things like this....

 

Now if Alteryx only allowed you to search for fields in the Select (and similar) tools.

Labels