Hello everybody,
Please refer to the attached documents
Document LOCTYPE is a data sample
Document EXPETED RESULT LOCTYPE is how the data should look like when is done
Thanks
Solved! Go to Solution.
What is it you're trying to accomplish here. I can see the example dataset and the expected output....but what rules are you trying to apply? If there's multiple of the "Name" then the consecutive ones "LOCTYPE_ID" change to a 2? Some more information would be helpful to see what it is that you're trying to do.
@chukleswk Please refer "LOCTYPE_ID on the document 2
@EvansM Please see the above solution this produces the expected output.
@chukleswk Thanks a lot