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?
@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.
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?
