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.
Solved! Go to Solution.
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
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.