I want to create a group change in a transformation that comprase the data of the current record with the previous one. Exp.:
if currentRec.Groupname!= prevRec.Groupname
return currentRec.Groupname
else return ""
I tried to write a script but can't store the value of the record for the next line.
Any idea?
Standard asp.net coding will work here. You'll need to figure out how to get the "Groupname" unique for previous and current in your data returned.
<%# (Eval("CurrentGroupname") != Eval("PrevGroupname") ? Eval("CurrentGroupname") : "") %>
Please, sign in to be able to submit a new answer.