while using if-condition and write cell resources to get data from one excel into another excel, the alignment of data is not correct because during the subsequent iteration the values are getting overwritten. For example, while copying a range for transactions into designated columns in another excel file based on the condition whether its a cash transaction or online transaction, the entries based on the first iteration is getting overwritten in the second iteration because for both if-then and else condition the starting rows are same.
Hello @rajkanth.r,
You can introduce a counter variable. In your Write Cell activity, instead of leaving it at “A1” you can use: “A”+ counter.ToString instead. Afterwards, increment your counter variable.
1 Like