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.
I can not clean nor transform the data when I'm using somebody else's DataFlow. Therefore I used the following formula to create a numeric value for the field "Score":
ScoreVal = if(exact([Score],"#N/A"), 0, value([Score]))