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