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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

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