Hi everyone,
I am fairly new to Blue prism. I want to grade students based on their percentages, I am pulling the data from excel storing it in a collection and passing the collection's percentage field as input to the choice criterion, wherein I would compare the percentage with the range of numbers and write the grades accordingly back to the excel file in a separate column. I have not defined the structure of the collection simply for the fact that there may be hundreds if columns in an excel sheet and it won't be practical to define fields in that case, so blue prism will itself create the structure based on the excel sheet. I am using work queues.
The problem is, my collection.percentage field is getting the data as text type but I need it to be as a number type so that I can compare it in the choice stage, I have tried to change the percentage column in excel as number but to no avail, the data still remains text type. How could I go about it?
Thank you.
I am fairly new to Blue prism. I want to grade students based on their percentages, I am pulling the data from excel storing it in a collection and passing the collection's percentage field as input to the choice criterion, wherein I would compare the percentage with the range of numbers and write the grades accordingly back to the excel file in a separate column. I have not defined the structure of the collection simply for the fact that there may be hundreds if columns in an excel sheet and it won't be practical to define fields in that case, so blue prism will itself create the structure based on the excel sheet. I am using work queues.
The problem is, my collection.percentage field is getting the data as text type but I need it to be as a number type so that I can compare it in the choice stage, I have tried to change the percentage column in excel as number but to no avail, the data still remains text type. How could I go about it?
Thank you.