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. 

     

     

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

are you able to share the data?   when you say you have checked thoroughly, how have you checked?  can you do a unique list from each column and share those values?