What I'm trying to do is having one excel as an archive and other "live" data sheet when column "AddToArchive" is with value "yes" export the rows to the archive excel file and update the rows with blank values. Exporting works fine but the row update step stops at the first row. How can I solve this problem ?
Am i using the key column and key values incorrectly ?
Solved! Go to Solution.
Found the problem. Leaving string('') to make a blank cell on KeyColumn makes the "Update a row" update the same cell over and over again.
Found the problem. Leaving string('') to make a blank cell on KeyColumn makes the "Update a row" update the same cell over and over again.
User | Count |
---|---|
92 | |
45 | |
20 | |
19 | |
17 |
User | Count |
---|---|
143 | |
53 | |
42 | |
40 | |
31 |