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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

How to change the data type from an Excel source file

Atom

Hi,

 

I facing the following issue. I have an Excel file (.xlsx), in which there are various text fields larger than 255 characters. When I upload the source data using the "Input Data" tool, it seems to convert my data to string. As a result the text gets truncated. 

 

How can I fix this?

 

Thank you in advance for your help

Alteryx Partner
Alteryx Partner

Hi @MichaelB,

 

I did a quick cursory check and I am not able to replicate your problem. I tried the "General" and "Text" formats in Excel and both output to V_String, which adjust based on the input length.  You can confirm Alteryx is working properly by using the images below as directions to check if the input is coming in properly.

 

 

Connection String Highlight.jpgHighlight of a Connection String

Connection String Configuration.jpgText output for XLSXExcel String Output Check.jpgConfirmation of V_String for XLSX String InputConnection String Highlight.jpgHighlight of a Connection String

If you are seeing the same results as the same above:

 

I would recommend checking any tools that you have after input. If you have any of them set to "String" it will automatically cut off the excess over 255 character. I would suggest changing them to V_String to give you more length.  Also watch for Crosstab tool those are notorious for cutting fields short (they are default hard coded with a length). Most other tools will pass through the length unless altered manually. The last area to check is if you are overwriting any fields you must first alter the length with a Select tool before you extend the data length, otherwise it removes the excess.

 

 

If the input is still not coming in properly:

What format (in Excel) is the text string you are trying to import?  (Then we can run some more tests)

Highlighted
Atom

Hi Andrew,

 

With some delay (sorry for that) thanks a lot for you post. It helped a lot. 

Labels