Limitation of field size in Transpose tool

[zqsoh]

My header was cut off after transpose due to the size limit exceeding 255 characters. 

[danilang]

Hi @zqsoh 

Can you provide some sample data or at least some before and after screen shots?  The transpose tool does not limit the size of text columns and will increase the size of the resulting column to fit all the data.  

Dan

[zqsoh]

Hi Dan,

Thanks for the reply. But it was my column header that was cut off, not the data in the column.

[PangHC]

here the sample workflow. I faced similar issue.

@danilang 

[Qiu]

@zqsoh 
Check the comment from @DataNath here

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Default-Length-of-Field-Names-...

[danilang · Accepted solution]

Hello @zqsoh 

Sorry for the misunderstanding.  There does indeed appear to be a 255 character limit on field names, though it's not explicitly stated anywhere that I could find.  Depending on the number of long column names that you have you might be able to work around the problem.  If there's only one, just use the shortened name and just before your output, add new row to the top of the data with the complete field name and export without column names, by selecting the skip field names option.

If there are multiple and/or they're dynamic because you need to crosstab, calculate the hash of the value using the MD5 function appropriate to your needs, MD5_ASCII(), MD5_Unicode() or MD5_UTF8().  These should give you unique values that will be short enough to use for column names.  Add in a row of the correct column names before output again.

Dan