Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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