Generating Sequence Number for all active assignment of a person using Fast Formula

Content

We have a requirement to achieve rows to columns using HCM Extract & Etext Template. We have multiple active assignments and the intent is to capture all the active assignments one by one in a single row for a person

In my extract, I have Person UE at root level and Assignent UE connected to it. In eText template, I am planning to pull assignment based on the sequence number condition( e.g. [../Sequence_number= 2])

Hence I am looking for a way to pull Sequence number for assignments in HCM extract. If a person have 4 active assignments, it should pick sequence number from 1 to 4 for respective assignments.