I am trying to parse XML and extract node value within XML using Spark-SQL ,

I have a situation here where I need to get the previous value using Window Function, I am able to do that, the problem is: I need to change the result based on current field.