Forum Discussion
DataFormat.Error: Invalid cell value '#N/A'.
I'm trying to pull in a value from another table using merge. I'm getting the following error: DataFormat.Error: Invalid cell value '#N/A'. I've looked at other forums to determine what is causin...
Are you using excel as datasource? Sometime in excel in formulas you have value "#N/A" and that could be the root cause for this. You need to replace that value using query editor with "null" or space and I guess that will do it.
Transform > Replace Errors should do the job of cleaning #N/A from a single column or an entire table.
Would consider this best practice when inputting data from Excel, I haven't tried but I would expect this to collect other Excel failure defaults such as #Value errors.
This works perfectly!
Thank you.