Derive Chronology from the dataset

[umashankar_cns]

Hi Experts

Looking for some inputs to derive the chronology in a dataset ; sample below

Expecting to derive the following outputs

Thanks,

Umashankar

[ntakeda · Accepted solution]

Hi, @umashankar_cns 

I have created a workflow.

The output of the upper flow is a table,

the output of the lower flow is a string (Chronology field).

Step1. Check whether the first row matches ST and identifies the group.
Step2. Extracts the top and bottom rows within the group.

Please check the workflow for details.

[umashankar_cns]

This works

Thank you !