Default Length of Field Names in .xslx Input Data Tool

[ljkauffm]

Hello everyone,

Right now, I'm working through survey results that have some questions put together with statements such as the following as the field name:

"Q48_2 - Tools (e.g. Alteryx, Tableau, SSRS/ Report Builder) and Training
If you use any of the tools in the Analytics environment, please fill out this section. Please rate your level of agreement with the following statements. If you have no experience with the statement, please select N/A. - For whatever I need to do with data, I can always find the right analytics tool."

Unfortunately, when I import these results into Alteryx through the Input Data tool, it cuts the field name off to the following:

"Q48_2 - Tools (e.g. Alteryx, Tableau, SSRS/ Report Builder) and Training
If you use any of the tools in the Analytics environment, please fill out this section. Please rate your level of agreement with the following statements. If you have no experience w"

While I have seen a lot on these forums about character limit on values within the fields, I haven't seen anything about changing the limit Atleryx is placing on field names themselves. I'd like to keep the field names the same for now due to the workflow I already have set up that relies on the style these field names are written in. I've also tried renaming the fields in Alteryx manually with the Select tool, but it won't let me put in the same format with the embedded lines that I unfortunately need to stay in the field name.

These are my settings for my Input Data tool:

Thanks!

[DataNath]

Hey @ljkauffm it looks like you're hitting the 255-character limit here. Unfortunately, I'm not aware of any workarounds for this and may be a limitation of how the field names are stored: https://stackoverflow.com/questions/26197288/why-255-is-the-limit#:~:text=The%20limit%20occurs%20due....

Looks like others have had the same issue in the past:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/what-is-the-character-limit/td-p/91247

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Field-name-size/td-p/150960

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Field-Names-Too-Long-how-to-count-fiel...

Tried with the file as both an Excel workbook and CSV:

[KSowers]

Could you convert the Excel to CSV by chance? With a CSV in the input tool you can specify the field length

[ljkauffm]

I don't know if that would work, because as I've seen, that would change the maximum length of the values within the field, and not the field names themselves, I think. @KSowers