I have large data in one excel file with many columns. I have to do the following tasks:
For example, there are two columns in this excel file, “C” and “M”. I have to pick those rows where entries of C and M columns differ from each other.
Then I have to copy these rows into a new excel file but only keep three columns for example “G”, “H” and “V” in the whole excel file.
What I have did so far, I convert the excel into data table and then apply for each row loop on data table. Within "for each row ", I am checking the condition where entries of C and M are not same and if condition gets true then I am trying to add this row to a new data table. After that I have plan to use write range activity to write it into excel and then filter the desired columns.
But I am getting error at add row activity that “Add Data Row: Input array is longer than the number of columns in this table.”
Any help, how to solve this problem?