In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Error in Alteryx output

Paddi
8 - Asteroid

When I use the browse tool in Alteryx, the data is complete, but when I use the Output Data tool to export it to an excel, some values are missing, some become #NAME? #VALUE? 
Anyone knows how to deal with this?

4 REPLIES 4
Emmanuel_G
13 - Pulsar

Hi @Paddi ,

 

Can you please share with us an dummy sample of data to test and any screenshoot of error message in excel for more details ?

Paddi
8 - Asteroid

Thanks for your response, but it's not convenient for me to upload the data, it seems that any string start with '=' would disappear in the output excel, do you know how to solve this problem?

Emmanuel_G
13 - Pulsar

@Paddi 

 

This is because in Excel, the "=" sign allows you to call a function.

 

To solve the problem, you must prefix the "=" sign with a space to have " =" and there, it will work.

 

Find a test in attachement for more details. I apply this rule in formula tool.

 

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it helped.

 

Emmanuel_G_0-1663582088073.png

 

Paddi
8 - Asteroid

Thank you so much, it helps!

Labels
Top Solution Authors