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 table sample:

 

Sales Table Sample:

 

 

I can able to append these two tables successfully and disabled International Sales. However, when I tried to apply and close, I am getting the below error.

 

 

I have converted the zip code into number in both International and Sales tables and appended without any problem in the query editor. However, I am getting the above error when I tried to apply and close. Could you please advise what would be the problem?

 

 

 

 

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.

     

     

     

     

5 Replies

  • 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.

         

         

         

         

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

    Hi Anonymous,

     

    Has your problem been solved?

     

    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.