open id 

HomeGeneral Q & A

Changing from String to Integer in the Excel Messages in this topic - RSS

myname
myname
Posts: 7


2/25/2022
myname
myname
Posts: 7
I used the "set values in column" and build an array, however I need to input values as an Integer rather than string, i tried to create data and set value but didn't got the outcome I was looking for. When I open an excel I get an error message saying that number stored as text. Is there a way I can store "item 2" as an integer rather than string? I did try converter and didn't anything converting from string to integer



0 link
Guest


2/26/2022
Guest
Have you tried configuring the datatype of the columns on the excel first and then uploading it as your template? This would ensure that any data added into those columns by Decisions would assume that datatype configuration.
0 link
myname
myname
Posts: 7


2/28/2022
myname
myname
Posts: 7
I can not configure them in Excel first because these values will change consecutively depending on the approval of the assignment and I am getting all the data from the report.
0 link
Guest


2/28/2022
Guest
You can also look at using the "Set Numeric Value" step to add number cells to an excel file.
0 link
osman.zama@decisions.com
osman.zama@decisions.com
Administrator
Posts: 23


3/2/2022
osman.zama@decisions.com
osman.zama@decisions.com
Administrator
Posts: 23
Hello,

We recommend that you use the set numeric value step as suggested above for your query.



You can take a look at this documentation.


I have built an example and attached it here.


Please refer to that and let us know if you have any questions.

Regards


Osman Zama


0 link






Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software