Data Manipulation

[EvansM]

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  

[chukleswk]

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 · Accepted solution]

The attached workflow produces your expected results using a multi-row formula of: if [Row-1:NAME] = [NAME] then 2 else 1 endif

[EvansM · Accepted solution]

@chukleswk Please refer "LOCTYPE_ID on the document 2

[chukleswk · Accepted solution]

@EvansM Please see the above solution this produces the expected output.

[EvansM]

@chukleswk  Thanks a lot