I’ve got a curious issue with RPA Express. I am reading in numerical data from an Excel file and store it in a list (which RPA Express automatically interprets as a string). Then I compare the numbers with a fixed number (500 in my case) and set a new value for a certain variable, depending on whether or not the number o the list is larger or smaller than 500.
Now the curious outcome: while I can see that the sequence reads through the different numbers (I wrote them into a notepad file to check), the comparison always returns that the number is greater than 500.
I suspect that this is related to RPA Express internally converting a string into a number, or similar. However, how can I force it to interpret variables the way I want to? When specifying a list, there seems to be no option to distinguish a list of strings from a list of, e.g., numbers.
Somebody got an idea?!?
Thanks a lot,