Hi all,
i am getting this error on this workflow. How should i fix it?
Please change your excel file from read only format to editable format to avoid this error;
Thanks,
David
I am creating the excel with excel application scope and do not choose read only field. Then the robot throw the excel to google drive. How can i change form?
You are looping through the data table and changing the value while looping which is not possible @mazlumkacar. So, you can create a new data table with the same values using assign and while looping through one data table , modify the another one by using the indexes
Now it is working. But this time it says invalid data because of my data is “0” and i made group by aggregation’s aggregation type is double. How will i do it this time?
Now i am also change the “0” data type to double and it is working. But now i am getting this error.
Can you post the screenshot how you are passing the value to group by?
I haven’t tried group by till now @mazlumkacar
We can use this as well, can you try
CDbl(Table.Compute(“Column Name)”, “”))
Check this in the message box and if you got the right values, use it