Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting error when I tried apply and close?

Hi   I have four tables such as Sales, Product, Manufacturer and Geography.   I created the Sales table by appending two tables such as International Sales and Sales.   International Sales tabl...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    Try to use 'Replace Errors' feature.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

One of your numeric Column has a non numeric value. That is why you are getting this error.

 

Try filtering each of the numeric columns and check.

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Yes, zip column has a text that's what error says. This is very large dataset close to 80 MB. I tried with a filter but unable to see the full preview and can't locate the error. Do you have any other way? 

 

 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Try to use 'Replace Errors' feature.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.