How do I store information from the column Date to the variable?
The problem is that I don’t want to store the information from current row but from the row below it. (I will need it later on to compare something)
Do you know what I mean ?
I need later on in the autoation to compare: IF current row Date is diferent than line below current row then something but I dont know how to store information below current row
Use like this
CurrentRow(“Date”).ToString
I need the row below the current row.
The automation need to
Check current row, compare with the row below and if not the same insert empty row between but I don’t know how to get infromation from the row below
var 2 must be the content from the date column from the row below the current row, do you understand :P?
Delete the assign activity and add again.
Sometimes it is showing error like this.
This is not an error I just wanted to show what I mean.
How to store the information from the row below of the current row?
CurrentRow("Date").tostring
this I need 
You can’t get like that by using current row.
As I previously shared, we can store the previous value in one variable and compare that to the current row.
I will copy what you did, but I really need to understand why your way works because I’m learning this.
Thank you you are kind for helping.
Sorry for being chaotic with this 
have a wonderful day
But the problem is if I store it, then during the next excel row it will be overwritten no?
No, because we initialize the variable in outside for each and for first iteration we assign the first row value.
In second iteration if only two values didn’t match then it will overwrite(second if condition).
Hope you get it.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale