As stated in the title, I have trouble setting the value of a column of specific row( provided with key) using the current row’s data. I created an action that “Sets the value of a column” and added another one that references the previous action with “Execute an action on a set of rows”. The problem here is that the output being set is based on the column value of the target row.
Suppose that I selected row 10. I want row 10’s [Identification key] column to be copied in the [Selected key] in row 1. What happened is that row 1’s [Identification key] value is the one being put in the [Selected key], not from row 10. I hope you could help me on this.