Since I am new in this journey, I need your support to find a solution for my workflow.
I have a CSV file, from where I read the data in a datatable, which results in 96 rows divided in 3 columns (Date,Value1,Value2). After reading, I have to make the sum of values in columnB (SUM1), the sum of values in columnC (SUM2), and then the sum Total = SUM1 + SUM2
After that I have to copy this sum values and append to an excel file, which is updated day by day with the new info. The structure of all this activites should be outputed in a format as shown in the attached Output.xlsx file. When I execute it, the excel file generated by reading the csv, can’t perform the sum of the columns, it derives a 0 value.
Waiting for a feedback from your side to help me make it work!
Thank you in advance!
Output.xlsx (8.7 KB)