I have an issue during my mapping. I have pulled the source node to get the context changes and mapped to index(statistics) to get the values but the result it is giving as sequence number for each context change but my requirement is to maintain the same sequence number till the context change.
here is my requirement:
But I am getting the output as below:
So i have written an udf to achieve the requirement.
but my output is coming like this it is considering the null as well for context change:
Please help me on my requirement.