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

Excel Named Range importing string data as number

Highlighted
Asteroid

Hello, I've named a range in Excel where the data is strings (text) however when I import it into Alteryx it comes in as numbers. I can't figure out what the numbers mean (not the length of the strings, I checked).

 

Does anyone have any ideas?

Nebula
Nebula

Pictures...or it didn't happen.

 

@mattlukoff. Can you provide us with some sample data or some images at least?

 

Dan

Asteroid

@danilang  thanks. Here's a screenshot of the output from Alteryx. The numbers in the column ($ in million) are actually words in the Excel (for example Brand 1, Brand 2, Brand 3, etc)

 

example.png

Nebula
Nebula

Hi @mattlukoff 

 

Can you share an image of the Excel input file, specifically showing where the named range is defined?

 

Dan

Labels