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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Input Data tool from xls converts column to 'double' and loses all text values

Atom

When inputting data from an excel file some of my text values are converted to "Null". I assume that this is because Input Data tool automatically converted the type of my column to double, and deleted all values that have text in them.

 

Has anybody else encountered the same issue of data loss?

Is there any way to specify the format of each column when using Input Data from excel?

 

My current solution is to choose "first row containt data" in the input data tool, which converts all values to text type. And then use dynamic rename tool to pick-up my column names. But this seems like a complex solution for a simple problem.

 

My xls file attached. As soon as you input data, you can see that all Old Code and NEW Code columns have blank values from row 87.

 

Thanks!
Saulius

Highlighted
Alteryx Certified Partner

Hi @Saulius,

 

You're correct. Alteryx samples a set of rows to determine what the attribute the field with. Instead, use the option to tell the tool that the first row contains data. This will bring in all your values as Alteryx will have to force the fields to strings.

image.png

 

Attached is the workflow shown above.

 

Hope this helps!

 

Jimmy

Atom

That was a very quick answer. Thank you jrgo!

Labels