Forum Discussion

DanielHart's avatar
DanielHart
Frequent Visitor
5 years ago
Solved

Expression.Error: We cannot convert the value null to type Number

Hi All,   I am receiving the following error when trying to merge two tables:   Expression.Error: We cannot convert the value null to type Number. Details: Value= Type=[Type]   There are no ...
Need Help
  • DanielHart's avatar
    DanielHart
    5 years ago

    Hi vanessafvg,

    I have found the problem. Long story short, there was some bad data in a single json file I was parsing (out of a database of 20,000+ json files). Took a while to find it, but after filtering out that file, the problem is resolved. 

    Thanks for looking at my question though. 

     

     

DanielHart's avatar
DanielHart
Frequent Visitor
5 years ago

Hi vanessafvg,

I have found the problem. Long story short, there was some bad data in a single json file I was parsing (out of a database of 20,000+ json files). Took a while to find it, but after filtering out that file, the problem is resolved. 

Thanks for looking at my question though. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi DanielHart ,

     

    Could you please kindly Accept your reply as the solution to make the thread closed since your issue has been resolved ? More people will benefit from it. 

     

    Thanks in advanced!😀

     

    Best Regards,
    Eyelyn Qin