Forum Discussion

DCat1223's avatar
DCat1223
Frequent Contributor
9 years ago

Help with an error message when executing a keyword test.

Good afternoon, and thank you for taking the time to read this. I am having trouble with a keyword test. The piece giving me trouble is referencing a value in a spreadsheet in a column called “DCRA...
  • joseph_michaud's avatar
    joseph_michaud
    9 years ago

    The DB provider chooses whether a column is considered as data or text.  Changing the format of the data only changes the  view of the data, not the underlying value. What happens if you write a little test to read the values for a column one at a time and log them?

     

    For more information, check this article Using Excel Files as Data Storages and this Forum article Trouble getting desired excel data

     

DCat1223's avatar
DCat1223
Frequent Contributor

Another thing I find interesting is the HSA Weekly column header is formatted General, and the rest of the column is Currency, yet when I plug that column into the Code Snippet it returns the "-" in my message box as I would expect.  The Com Transit Month Limit is formatted exactly the same waya as the HSA Weekly column, and that returns the "Decline" as I would expect.  There is just something about the DCRA Annual Amt field I guess. 

joseph_michaud's avatar
joseph_michaud
Moderator
9 years ago

The DB provider chooses whether a column is considered as data or text.  Changing the format of the data only changes the  view of the data, not the underlying value. What happens if you write a little test to read the values for a column one at a time and log them?

 

For more information, check this article Using Excel Files as Data Storages and this Forum article Trouble getting desired excel data