I want to subtract values from two columns in an Excel file, and write the results to three different output Excel files depending on the results of the subtraction: negative, positive or zero.
I have created a ‘Read Range’ activity to read the original Excel file, ‘For each row’ to iterate through the rows and then an ‘If’ control where in condition I wrote something like: cint(row(1)) - cint(row(2)) < 0 then ‘Write Range’ activity to write to a new Excel file with the original Excel file as an input (to get the file with only those with row(2) is smaller than row(1)) . I get the original file generated with no change. Any idea? Thanks.