Forum Discussion
DataFormat.Error: We couldn't convert to Number.
Hi, basically my database consist of staff id..now most staff id are all digits, for example
1234
4519
8901
However, there are staff id which includes a letter, for example
B1290
C9021
The error states DataFormat.Error: We couldn't convert to Number. - but the thing is my data type is not set to numbers (it is set to this logo ABC123, and i have also tried setting the type to text but it did not work. Please help
4 Replies
Could you provide the steps out of the advanced editor? It might be that PQ converts your column automaticly or in there's a conversion in an earlier step.
If you add a new step at the end with keep errors. You will only get the rows with values that give an error. That might help in pin pointing where the error occurs.
There are occasions when the error message DataFormat.Error: We couldn't convert to Number is misleading as the real issue is with a calculation on a totally different step.
For example I was doing a simple Free Inventory + Quarantined Inventory calculation but there was an Error value in a single Quarantined Inventory field and I was getting the DataFormat.Error: We couldn't convert to Number error message on the last step of my query even though the calculation was done several steps before!
Although this doesn't directly answer your question it might give you a starting point (you could copy the query then delete steps one at a time until you find the error goes away then you know the last step you deleted had the problem??)
