Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error Messages

Hello All,   I have 3 tables in my data model, all have the same source.   I have it 3 times for security reasons.   For some reason I keep getting this error message that there are 72 errors o...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Open Edit Query/ Data Transformation from home Tab. There you will see error in yellow

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Here it is, am I missing something?

     

    • camargos88's avatar
      camargos88
      Community Champion
      6 years ago

      Hi Anonymous ,

       

      Check the values before convert them.

       

      The columns:

      Scheduled Hours Earnings,

      Hours Used Earnings,

      LWOP Earnings

      have the character $, first remove it and change the datatype to numerical type.

       

      Also the column Add_Email_1 is as numeric, it has text values.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        You mean make the changes in the excel file before I refresh the data?