Hi! I want to compare worksheet rows of two similar Excel Sheets in order to keep them synced (the second one is passive and with less information) if there have been changes.
I use the List Worksheet Rows > Array aggregator for both sheets and use an Iterator to start comparing the values. This is where I’m stuck.
Via filter, I want to only update worksheets rows, where the value of Row I of the first Array is not equal to the value in the second Array in the same (iterator) position.
I have tried several things with map and get functions, but it seems that I don’t get the syntax of that second part right and I don’t want to confuse you.
My Iterator looks like this:
And I want to compare that value (16) to the value (15) of this second Array:
Or is there maybe any other better way to do what I want?
Thank you so much in advance !