Forum Discussion
Solved
Unpivot causing [DataFormat.Error] Invalid cell value '#N/A' on date field
Hi, I have a simple table (10k rows) with a column for date and three columns for persons. I unpivot the three columns for persons into a single columns. My date field seems fine just before the unpi...
jschuchter , just check you number field might have got - or N/A or null or #NA
In edit query run auto-detect data type and check does it change the data type
Hi jschuchter ,
You may enter into Query Editor, remove the step "Change Type" behind of step "Source" .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-xicai
Community Support
Community SupportHi jschuchter ,
You may enter into Query Editor, remove the step "Change Type" behind of step "Source" .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.