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?
Solved! Go to Solution.
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 ?
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?
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.
Thank you so much, it helps!