Forum Discussion

Jeffrey2's avatar
Jeffrey2
Icon for Helper I rankHelper I
4 years ago

Expression.Error: We cannot convert the value 1110011 to type Text.

We have a daily report that we run with no issues. Today we received the "Expression.Error: We cannot convert the value 1110011 to type Text." message and it doesn't make sense. The source spreadshee...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

At the bottom, you will be able to see column profiling based on Top 1000 rows. Click it and change it to entire data set. 

Now, go to View menu and check column quality box. See if any column (not necessarily this column) is showing Error. 

If yes, go to Home menu - Keep rows - Keep errors

Then you will be able to analyze error. 

Jeffrey2's avatar
Jeffrey2
Icon for Helper I rankHelper I
4 years ago

Thank you for the response. I did not know about that feature so that was good to know. 

 

However, strangely enough, every column shows Valid 100%. When I select "Keep Errors", I still get the Expression.Error: We cannot convert the value 1110011 to type Text. message.

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Create a duplicate query and before the final step, Home, remove rows, remove blank rows and then see what final step is giving.

    • Jeffrey2's avatar
      Jeffrey2
      Icon for Helper I rankHelper I
      4 years ago

      Same error message

      • Jeffrey2's avatar
        Jeffrey2
        Icon for Helper I rankHelper I
        4 years ago

        Let me add this... I already have a step where it is supposed to remove any IDs that DO NOT begin with two letters. Even after that step, the IDs similar to 12345 are appearing.