Skip to Content
0
Feb 05, 2021 at 01:32 AM

same sequence number till the context change in queue by keeping the null as is from source

40 Views

Hi Experts,

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.

Attachments

expected.png (70.4 kB)
actual.png (60.1 kB)
udfcode.png (60.3 kB)
udfoutput.png (80.9 kB)